Timezones

[way2bord]

When logging time (Now, Date, etc.) - how does access handle Timezones?

ie. Will 2 people entering data on opposite sides of the world at the same time have a table entry that reflects 2 different dates?

 

[billmeye]

Time of day is handled by Windows. Your likely to get different dates from different locations. But, if the data is on a single server I believe the time will be pulled by that system so it might be the same regardless of where the front end gui is located.

 

[way2bord]

Any reccommendations on how to compensate for time discrepancies?

ie. Method of adjusting all data input to GMT for a universal display for aggregation? Or forcing front-end to use serverside data for time calculations?

or... other suggestions?

:banghead:Creating database file logs turned interesting when it dawned on me that my values could all be off by a number of hours...

 

[catalin.petrut]

You better leave the sistem date/time? If your aplication is used by more people from different timezones, maybe you will need to know the time that employee was working.each now() is different becouse it should be different. My now is now, at 10:22. I bet your now is later, when you read the post.

 

[Pat Hartman]

Since the date comes from the computer running the process, you will need to pick a time zone and adjust all entries as they are made to the "standard" zone. Use GMT or "headquarters". Don't forget to account for daylight savings time if some of your locations us it.

 

[way2bord]

Since the date comes from the computer running the process, you will need to pick a time zone and adjust all entries as they are made to the "standard" zone. Use GMT or "headquarters". Don't forget to account for daylight savings time if some of your locations us it.

What is the typical process for standardizing a time?

The process as I see it: ...
To convert all times to a consistent timezone (GMT for example), I need to A) determine user's timezone, B) determine difference between user timezone and GMT, C) manually add/subtract time difference?

While I can do B and C easily enough - I'm not entirely sure the process for A...

Or is there an automated switch I could flip that just says - all formula in this database will calculate as if it were a specific timezone?

 

[spikepl]

Not to be bitchy, but one of the most underrated developer skills is avoidance of reinventing the wheel and building on the work of others. Ask yourself if anyone is likely to have had a similar problem before? If you think yes, then what tools exist to assist you in finding the solution?

 

[Pat Hartman]

I searched for "vba code to adjust timezone" and this is the first link that came up in Google.

http://www.cpearson.com/excel/TimeZoneAndDaylightTime.aspx

 

[way2bord]

Not to be bitchy, but one of the most underrated developer skills is avoidance of reinventing the wheel and building on the work of others. Ask yourself if anyone is likely to have had a similar problem before? If you think yes, then what tools exist to assist you in finding the solution?

I searched for "vba code to adjust timezone" and this is the first link that came up in Google.

http://www.cpearson.com/excel/TimeZo...lightTime.aspx

I stand corrected.

I was holding out hope for a one-liner-built-in feature so I could avoid the hassle of reviewing a new function or blackboxing a process.

Thank you for the help and the links.