How can I convert GMT time to EST time in MS Access?

Does anybody know how to convert GMT time to EST time in Access?

Thank you!:)

Quote:

---

Originally posted by Joanny
Does anybody know how to convert GMT time to EST time in Access?

Thank you!:)

---

What do you mean in Access ???? I do not think Access has any built in function that will do this kind of converion :p .. Write code pal ...

Thanks

Actually I get the data from server and they are a txt format, then I import to Access, that's the GMT time, I have to convert them to EST time, how should I do?

Well, I can tell you from experience that Central time is -6GMT.... and Eastern is -5GMT..... and Pacific is -8GMT......

So, if you have the current time in GMT....
Subtract 5 hours to get the Eastern time....

I know I need to add 4 hours to it at here. But how should I add it?

Quote:

---

Originally posted by Joanny
I know I need to add 4 hours to it at here. But how should I add it?

---

Use the DATEADD function.....

Got it!

Thank you!