ACCESS FEED: RE: [MS_AccessPros] now() with time zone adjustment

Kamis, 05 Juni 2014

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

http://www.viescas.com/

(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

http://www.viescas.com/

(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

http://www.viescas.com/

(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 |

beaerospace.com

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.