Trying to convert data/time field to a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top