Trying to convert data/time field to a date

[Guest]

Hi

I am linking to tables from an Oracle db and I need to convert the data/time
fields to date fields but just using Cdate does not work.

I have to take the field convert it to text then use Cdate to covert it to a
date.
Open_Time ***is the field***
Open: Format([Open_Time],"mm/dd/yyyy")
OpenTime: CDate([Open])

My steps above works but I am hoping their is a better way?

Thanks

 

[Douglas J. Steele]

Better is to use DateValue([Open_Time])