Date Format In Table

Hi All,

The following code is supposed to insert a date formatted as dd/mm/yyyy into a table, when i view the mySQL string in the debug window it shows the correct format, however when i open the table it displays the date as mm/dd/yyyy.

The table's date field userdate is formatted as a short date field with an input mask of dd/mm/yyyy.

My computers date settings are set up as dd/mm/yyyy as well

Any ideas on hows to correct this?

Thanks in advance. :)

Public Function Test()

Dim mySQL As String
Dim dtDate As Date
Dim db As Database
Dim qdf As QueryDef

Set db = CurrentDb()

dtDate = Format(Now(), "dd/mm/yy")

mySQL = "INSERT INTO tblCurrentUser( userdate ) values (" & "#" & dtDate & "#" & ");"

Debug.Print mySQL

'*The debugger shows* INSERT INTO tblCurrentUser( userdate ) values (#04/05/2005#);

' However the value in my table tblCurrentUser is05/04/2005 is in mm/dd/yyyy format

Set qdf = db.CreateQueryDef("", mySQL)
qdf.Execute

End Function