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

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

fredg

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])
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to convert GMT to EST? 3
Only can select GMT as a time zone - want to select EST 7
Time conversions from EST with daylight saving to GMT 3
Does UTC account for GMT Daylight Saving? 2
How do I Convert TEXT to EST Time ? 11
datetime conversion from UDT/GMT to localtime 5
Convert local time(eg EST) on local machine to GMT 1
Changing time zones 2

Top