Extracting Date from Date/Time Field

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

Guest

I need to extract just the date portion of a date/time field in order to
compare with another date field to calculate number of days between the two.
Can someone please assist with how I go about getting the date only portion
from the date/time field?
 
Use the DateValue function:

DateValue(DatetimeField)

There's an analogous TimeValue function should you need it as well.
 
Brilliant. It worked. Thank you very much.

Douglas J. Steele said:
Use the DateValue function:

DateValue(DatetimeField)

There's an analogous TimeValue function should you need it as well.
Click to expand...
 
Back
Top