I have a database that has all of the dates / time fields stored in UTC time. I need a function in access to display the date / time based on the local time zone.
Example: in sql i have a date / time stored for a change to a record and it is 5 hours ahead of my local time.
in sql 9/4/2012 5:15:27 PM I'd like to view this in
access in central time (GMT -6) - 9/4/2012 12:15:27PM
Thank you in advance.