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