SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to change time zone on DateEntered

    Can someone tell me how to either change the time zone or add three hours to the following?

    Dim DateTimeEntered
    John Saunders

  2. #2
    Guru Bullschmidt's Avatar
    Join Date
    Apr 2002
    Location
    USA
    Posts
    524
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here's how I often do it:

    mintServerToOrgHourOffset = 3

    mvarOrgDtTime = DateAdd("H", mintServerToOrgHourOffset, DateTimeEntered)
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

  3. #3
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried your code but it keeps showing up as 3:00:00 AM instead of the current time. Any idea what the problem is?
    John Saunders

  4. #4
    Git-R-Done
    Join Date
    Nov 2001
    Posts
    1,194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nevermind, my mistake. I had taken out the DateTimeEntered = Now(). Thanks for your help!
    John Saunders


Bookmarks

Posting Permissions

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