Date extraction from Datetime field

[kbrown73]

crystal 8.5, ODBC, Access Database


How can I extract just the Date from a datetime field. I am trying to use the Datepart function, but it is returning errors...

my format needs to be mm/dd/yyyy

Thanks in advance.

 

[gazol]

Try DateValue like this:

DateValue ({DATABASE.TIME})

 

[kbrown73]

That works, thanks...