Time Zone Date variables

B

Bill

I am connected to a SQL file with a date field as a data type = 'LOCAL_TIME'.
It displays as an interger in my query. How do I convert it to a date the
users will understand? Time zone variable? Universal dates? Convert?
Click to expand...

It is a ten digit numeric field.

I am working in a Query. I tried the date formatting but that didn't work.
At least it didn't work the way I did it. More information and/or an example
would be nice.
 
D

Dale Fye

Try the CDATE() function. This should convert the numeric date into a date
that makes sense.

HTH
Dale
 
B

Bill

Dale,

The CDDate function doesn't work.

It isn't a numeric date per se', it is a ten character numeric (UTC)
Universal Date.
 
Top