Extracting Date from Date/Time Field

[robbie]

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?

 

[Douglas J. Steele]

Use the DateValue function:

DateValue(DatetimeField)

There's an analogous TimeValue function should you need it as well.

 

[robbie]

Brilliant. It worked. Thank you very much.

Use the DateValue function:

DateValue(DatetimeField)

There's an analogous TimeValue function should you need it as well.