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?
 
D

Duane Hookom

Add or subtract some value to the integer and set its format to date in your
report of form control.
 
J

John Vinson

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...

What kind of values occur in this field - integers 0 to 23? If so,
it's probably the hours offset from Universal Time, and you should be
able to use DateAdd() with some other field (which might be an actual
date/time field). Insufficient info!

John W. Vinson[MVP]
 
Top