Time Zone Calculation?

[egun]

Let's say I'm using my database somewhere in the U.K., but I want to know
what the date and time are in Fort Worth, TX. I need to know this because,
during a specific period of time on a specific day of the week (local to Fort
Worth), I'm not allowed to make any changes to the database. I won't say
why, because that's a long story...

How can I determine what time it is and what day it is in Fort Worth from
wherever I am, either in the U.S. or in the U.K.? I can hard code the fact
that Fort Worth is GMT - 6 hours, but how can I determine the offset of
(local time to Fort Worth time) and whether or not Daylight Savings Time is
involved? Specifically, I want to know if it is Monday, between 07:00 and
10:00 in Fort Worth.

Thanks,

Eric

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/api/api0024.htm at "The Access Web"
helps.