G
GHF
I have a database where every record in a certain table is assigned to a Time
Zone, mostly in North America, but also around the world.
What I would like to do is to have a field on a form that takes the current
system time, and calcuates the time at that location, so I can see it without
some sort of mental gymnastics.
For example, I am in the Eastern Time Zone, and the system time on my system
says so. I know that anything in the Central Time Zone is one hour behind.
If I know that, how do I calculate that the current time in Chicago is 1722,
when the current system time is 1822 here in Orlando?
Zone, mostly in North America, but also around the world.
What I would like to do is to have a field on a form that takes the current
system time, and calcuates the time at that location, so I can see it without
some sort of mental gymnastics.
For example, I am in the Eastern Time Zone, and the system time on my system
says so. I know that anything in the Central Time Zone is one hour behind.
If I know that, how do I calculate that the current time in Chicago is 1722,
when the current system time is 1822 here in Orlando?