date/time

B

Bob

How can i separate the date from the time. I only need the date value and not
the time. Is this possible.
 
V

Van T. Dinh

DateValue([YourField]) will give the date component.

TimeValue([YourField]) will give the time component.
 
P

Pete

You can use
Datevalue(Datetimefieldname) to give you just the date.

Bear in mind that you cannot store a date without a time - a default time of
00:00:00 is assumed.
 
Top