There’s a standing joke in Canada, Duane, because Newfoundland is one of those “00:30:00” zones. Television schedule times are often quoted as 8:00 Atlantic, half an hour later in Newfoundland. The standing joke is: “The world will end tomorrow, half an hour later in Newfoundland.”
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 5, 2014 1:33 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] now() with time zone adjustment
John,
I had no idea there were time zones that use ":30:00". I thought you were joking until I searched the web prior to embarassing myself ;-)
Duane
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Thu, 5 Jun 2014 12:08:00 -0500
Subject: Re: [MS_AccessPros] now() with time zone adjustment
Well, how else would you do it?
Another idea - if each user has his or her own copy of the front end, send them a copy customized for India. Instead of saving Now() in the India front end, save Now() - #05:30:00#
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 5, 2014, at 11:08 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Oh…. So I would have to do this by username?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 05, 2014 8:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] now() with time zone adjustment
Liz-
The most common thing to do is associate a UTC offset with each user. +0 is UTC - or Greenwich Mean Time. US east coast is -5. Central Europe is +1. India is +5.5 (they are on an odd half-hour offset). So, to convert India time to US east coast, you need to subtract 10.5 hours.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 5, 2014, at 10:33 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi John, thanks for your quick response.
I don’t have info in my db that gives me location or time zone of the user. Is this something I can do? If so, I’ll do it and then take it to the next step. How would I go about getting something for location or time zone?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, June 05, 2014 8:03 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] now() with time zone adjustment
Liz-
Do you have info in your database that gives you the location (or time zone) of the user? If so, you can write formulas to adjust the time to something standard like UTC or the time zone of headquarters.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jun 5, 2014, at 8:06 AM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Pros, I have a database used in 5 different countries, India being one of them. I capture log in time and log out time as well as other activities with now(). Is there a way I can adjust the time because it is fouling up my stats. I just got informed I have 30 more users in India, so it is getting to be more important.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar