2. ASPRunnerPro General questions
  3. Timezone format
This topic is locked

Timezone format

 		3/3/2007 12:49:40 PM
ASPRunnerPro General questions
D
 DNuccio author

I have a fields called "LAST UPDATED" where on edit dict("LAST UPDATED") = Now() This function works correctly however the time is six hours ahead and my Regional setting is set to English (United States). Is there a format I can use after the Now() to subtract the six hours so that my database field shows the correct hour?
Thank you in advance..
Sergey Kornilov admin 3/3/2007

Try the following instead of Now():

DateAdd("h", -6 , Now())
D
 		DNuccio author 3/3/2007

Thank you. That worked perfectly.