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])
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Query too long therefore will be truncated 2
Not including Weekends and Public Holidays! 4
Report Error 2
Why is my report crashing 2
Make statement alittle bit shorter! 1
Date Question! 3
Getting something completed following Month 3
Question on Nested IIF Statement 8

Back
Top