ASP VBScript Access Database

[shragel]

I have a access database on ASP VBScript.
The actual server is in england I am in the US.
I use a insert into SQL to add data to the database.
I have at the start of every page Set locale 1033
But when it saves in the datbase the date it turns around the Month and day. and when i download it it get mixed up.
What can i do to fix it.
Thanks

[shragel]

Its a asp hosted porvider. i do not control the server. I use fhr FormatDateTime() Function. Here is the code.

SetLocale 1033
 
          strsql = "Insert INTO Logged (AcountNum, Name, DateL, IP, RHost) Values (" & Session("AcountNum") & ", """ & Session("ComNme") & """, '" & FormatDateTime(Now, 2) & " " & FormatDateTime(Now, 4)  & "', '" & Request.ServerVariables("REMOTE_ADDR") & "', """ & RHost & """)"

[alex_read]

Not heard of that one before, might take a look at what that does this afternoon. In the past I've used :

format(now(), #ddmmyyyy#)

(been a while since I've played with that function so you might want to check that syntax a bit but that's the general idea that usually works).

[shragel]

I am working with VBScript on ASP. there is no Format(Now, "M/D/YY") Function there. Only FormatDateTime()