SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
-
Apr 15, 2005, 06:10 #1
- 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 DateTimeEnteredJohn Saunders
-
Apr 25, 2005, 18:25 #2
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
-
Apr 27, 2005, 09:18 #3
- 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
-
Apr 27, 2005, 09:25 #4
- 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