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.