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

VB Code:
  1. Function americanisedate(englishdate As Date) As String

  2.  
  3. americandate = Mid(englishdate, 4, 2) & "/" & Mid(englishdate, 1, 2) & "/" & Mid(englishdate, 7, 4)

  4.  
  5. americanisedate = americandate

  6.  
  7. 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.