Results 1 to 1 of 1
  1. 08-01-2010, 03:01 PM #1
    zapper222
    zapper222 is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2010
    Posts
    2

    Convert local time to UTC

    In my database I display time of entry but I want to display this time in UTC. I presently use a module of VB code that adds a number to the present time before it displays the time but I have to change this everytime we go from DST to standard time. VB code exists that does this automatically using Date.UtcNow but I am not having any success getting this to work in Access and I am not sure what the problem is. Does anyone have a working model they could share or know how to solve the problem. Thanks Zapper
    Last edited by zapper222; 08-02-2010 at 09:20 AM.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Convert to ACCDE through VBA
    By johnrt87 in forum Programming
    Replies: 0
    Last Post: 06-28-2010, 07:50 PM
  2. Web MySQL using local MS Access - Help...
    By tsaw in forum Access
    Replies: 0
    Last Post: 05-14-2010, 08:43 AM
  3. convert txt file
    By anu in forum Programming
    Replies: 1
    Last Post: 04-18-2010, 10:20 AM
  4. Form fields export to local table
    By lupis in forum Forms
    Replies: 0
    Last Post: 03-23-2010, 02:38 PM
  5. Convert to MMM/YYYY
    By Brian62 in forum Queries
    Replies: 10
    Last Post: 08-31-2009, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums