convert Access data stored in in time format (GMT) to EST

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

Guest

I have imported data from an Informix database, but the time stamp is in GMT.
How can I either convert it to EST or display it in a report in EST?
 
I have imported data from an Informix database, but the time stamp is in GMT.
How can I either convert it to EST or display it in a report in EST?
Click to expand...

Isn't EST 5 hours behind GMT?
=DateAdd("h",-5,[GMT Time Field])
 
Thank you. I actually found the function after I posted this.

fredg said:
I have imported data from an Informix database, but the time stamp is in GMT.
How can I either convert it to EST or display it in a report in EST?
Click to expand...

Isn't EST 5 hours behind GMT?
=DateAdd("h",-5,[GMT Time Field])
Click to expand...
 
Back
Top