SQL syntax for date

[Wajiha]

hi....this website has got me going...i need help with the syntax of the following SQL in vb....cant seem to get the date into the SQL properly. Please help....thanks!!! Need to find age older than certain date!!

the SQL syntax for Date ?

Dim dSearch AS date

dSearch = InputBox$("Enter date to show employees older than","QUERY")

Data1.recordsource = "SELECT * FROM StaffDetails WHERE StaffDetails.[Date-of-Birth] <= " &dSearch

I thought about not putting the speech marks after dSearch as it is a date and not string....any suggestions??? Many thanks

[ae_jester]

u need to use # before and after dates in SQL.

ex.

rs.Open "SELECT * FROM tblWhatever WHERE birthDate = #" & txtDate.text & "#"

[cafeenman]

You have to surround dates with the pound symbol

sSQL = " SELECT * FROM TABLE WHERE MY_DATE >= #15-JAN-2001#"