Time convertion

[Muzicmn969]

I've searched but havnt found this question posted.....

This is the situation, I created a data base for the government that tracks times that airspace goes active and when it goes "cold". so far so good

The times entered are in Greenwich time, or military time (zulu time). I am in the EST. times are off by 4 hours.

Problem happens when a search page is refreshed.....
since the times are entered in zulu time, the computer is looking at the local time (on the computer) to do the refresh. I would like to tell access to subtract the 4 hours so the times match up but still want the zulu time displayed in the database


I cant simply change the local time in the computer because in other databases the local time is needed.

any ideas????

 

[FoFa]

DATEADD("h",-4,now()) will give you 4 hours behind while DATEADD("h",4,now()) will give you 4 hours in the future from the local time.

 

[Muzicmn969]

WORKS LIKE A CHAMP ! ! !


THANKS ALOT FOR YOUR HELP


RICKY