Extract Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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])
 
Thanks alot, that worked!

Allen Browne said:
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.

JOM said:
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])
 
Back
Top