Extract Date

[Guest]

My field has a date and time, and I would like to only extract the date and
not the time, how do I do this! e.g., 12/25/2005 10:00 AM to only 12/25/2005

I have the following statement.......
WeekNo: "Week No. " & DatePart("ww",[RqstDateRcvd]) & " Dates From "
& DateAdd("d",1-Weekday([RqstDateRcvd]),[RqstDateRcvd]) & " -- " &
DateAdd("d",7-Weekday([RqstDateRcvd]),[RqstDateRcvd])

 

[Allen Browne]

Use DateValue() to get the date without the time.

 

[Guest]

Thanks alot, that worked!

Use DateValue() to get the date without the time.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

My field has a date and time, and I would like to only extract the date
and
not the time, how do I do this! e.g., 12/25/2005 10:00 AM to only
12/25/2005

I have the following statement.......
WeekNo: "Week No. " & DatePart("ww",[RqstDateRcvd]) & " Dates From
"
& DateAdd("d",1-Weekday([RqstDateRcvd]),[RqstDateRcvd]) & " -- " &
DateAdd("d",7-Weekday([RqstDateRcvd]),[RqstDateRcvd])