[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 595
  • Last Modified:

Convert utc to local time

How do I create a function in ms access 2002 to convert UTC time to local time?
0
Joe_Greene8900
Asked:
Joe_Greene8900
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now