Dates in Access SQL

[Oliver1]

For all you british people out there, or people who have dates in the following format
dd/mm/yyyy

How do you insert the date into sql. For example I have a combo box which gives the user a list of dates, I then want to look up a value from the databse depending on the specidied date. Curretly I am converting the date as follows

Function americanisedate(englishdate As Date) As String
 
americandate = Mid(englishdate, 4, 2) & "/" & Mid(englishdate, 1, 2) & "/" & Mid(englishdate, 7, 4)
 
americanisedate = americandate
 
End Function

I just feel there must be a better way, as I understand dates are actually stotred in the database as number of seconds elapsed since 1900 (or some such).

Anyway hope somebody understands what I'm waffling about and can help.

[Br1an_g]

Dim MyDate as Date
 
MyDate = Date()
 
MyDate = Format(MyDate,"dd/MM/YYYY")

or thereabouts.

HTH

[Ecniv]

Format(<date var>,"dd mmm yyyy") <--- Access useage
Format(<date var>,"mm/dd/yyyy") <--- any sql useage (american formatting)

[Oliver1]

Thanks will give it a go.

Still makes me cross, is mean the British don't have an empire anymore, and we now have to follow one of are ex colonies standards.

Only jokes, without America we wouldn't have great TV shows like 24.