need to format the date so that SQL server can insert it into the database at your local time?
<br><br>

ASP Code:
<br>


<textarea cols="90" rows="5">

DateString = Right((year(now)), 4) & "/" & month(now) & "/" & day(now) & " " & time()
Response.write(DateString)
</textarea>
<br><br>

Returns this time string:
<br>

2012/5/19 23:22:47

<br><br><br><br>

<textarea cols="90" rows="5">

DateString = Right((year(now)), 4) & "/" & month(now) & "/" & day(now) & " " & DateAdd("h",-1,time())

</textarea>
<br><br>

Returns this time string (minus one hour):
<br>

2012/5/19 22:22:47