G Guest Oct 27, 2006 #1 How can i separate the date from the time. I only need the date value and not the time. Is this possible.
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 Oct 27, 2006 #2 DateValue([YourField]) will give the date component. TimeValue([YourField]) will give the time component.
DateValue([YourField]) will give the date component. TimeValue([YourField]) will give the time component.
G Guest Oct 27, 2006 #3 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.
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.
