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?
LVL 1
wsturdevAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Chuck WoodConnect With a Mentor Commented:
To get "EST" and other abbreviations, you would need to create a function that converts the full name to the abbreviation.

To get the offset, you should import the module into your database (Visual Basic window => File => Import File => navigate to the file => select the file => Open. You can then use the LocalOffsetFromGMT function.
0
 
Chuck WoodCommented:
I think this will meet your needs:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20877498.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
0
 
wsturdevAuthor Commented:
I looked at the link.  I have never seen such a construct before.  Where do I place it?
0
 
Chuck WoodCommented:
You place it in a separate module.
0
 
wsturdevAuthor Commented:
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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.