I have a dilemma that I can't seem to solve. I figured if anybody can come up with a solution it would be gk53!
It's regarding changing an EST server time zone (now()) to my local AZ time for time stamping in my logs. (3 hrs difference)
This problem only occurs during the fall Daylight Savings time drop back in time for 1 hour.
The dilemma is when EST time goes to 2:00:00, I don't actually drop to the 2 hours difference because at 2am EST, it actually then goes to 1am EST which still puts me at 3 hours difference until I hit 2 am again. It self corrects at the new 2am EST, which I am then at midnight.
if cdate(Now()) < CDate ("11/04/2012 2:00:00") then
aztime = dateadd("h",-3,now())
aztime = dateadd("h",-2,now())
So I have a 1 hour time span that my time is off for 1 hour.
Maybe it's unsolvable.