How to convert Now() to Eastern Standard Time

[bradyboyy88]

Hi,

I have multiple users across the US using my application and I utilized the now() function. So is there way to convert all of these now() to eastern standard time because these time stamps are saved in my access database.

Thanks

 

[Joe4]

I believe that NOW() is dependent on your regional time settings (I am in the Eastern Time Zone), and NOW() returns the correct time.

So, if it returns something different for you, then your regional time settings is probably something other than Eastern Time, so you would just need to offset your time by that.

You can do that by adding/subtracting the difference in hours divided by 24, i.e.
=Now() + (hours/24)
or
=Now() - (hours/24)
where hours is the difference in hours between your regional settings and the Eastern time zone

 

[bradyboyy88]

Thanks for that.

Well the issue is trying to account for all the different zones and the amount to add. So I used cpearsons method of converting to GMT then adding 5 hours for EST. Link to his site is below:

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