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.