Find out local system time zone?
In Access 2007, how can I find out the time zone being used by the local system, or better yet, the offset from the current local time zone to GMT?
ASKER
I looked at the link. I have never seen such a construct before. Where do I place it?
You place it in a separate module.
ASKER
I figured out where to place it. It gives me the name of my time zone ("Eastern Standard Time"). What I would rather have is "EST" and the offset to GMT (-5). How can I get that?
regarding the modTimeZones.zip, I unzipped it and changed the extension, but now what do I do with it to get at the functions?
regarding the modTimeZones.zip, I unzipped it and changed the extension, but now what do I do with it to get at the functions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/questions/20877498/Get-Time-zone-from-System-settings.html?sfQueryTermInfo=1+time+vba+zone
If not, unzip the attached file, change the extension to .bas, and use the functions in this module.
modTimeZones.zip