Solved

Convert utc to local time

Posted on 2008-10-23
1
586 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!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

785 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