Solved

Convert utc to local time

Posted on 2008-10-23
1
587 Views
Last Modified: 2013-11-27
How do I create a function in ms access 2002 to convert UTC time to local time?
0
Comment
Question by:Joe_Greene8900
1 Comment
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 22789500
See if this gives you the jist:
http:Q_22763998.html

You create a function that takes UTC time and does a dateadd to subtract 4-5 hours based on daylight savings time.  You can see the additional logic there, which you may need to adjust for new daylight savings rules.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question