MS Access - How to handle multiple time zones?

Question

I have a MS database that I need to migrate from the US to Belfast, Ireland. Before migrating the database I want to test some of my time check procedures to see if they will work when being used in a European time format. For example I test all files that are loaded into the database to see if they are older than 3 hours. I also test if the file is older than one day.

Should I just change my time in my computer settings to a European format to determine if my code will work. What are your suggestions ?

Answer 1

DateTime in Access is stored as a float. How it is expressed depends on the locale being used by the computer running Access; it's not stored in "European" or "American" format.

What you really mean is you want to ensure that the proper format is used when entering date and time in the database, so that you don't have conversion problems when inputting the data.

Access automatically uses the locale of whatever computer it is on. So, if you change your Region and Language settings to Ireland in the Control Panel, Access will use European date and time settings.

Answer 2

I would test the database and deduct the time between time zones. =o)