:h:
strSQL = “SELECT matri.* FROM matri WHERE matri.d_dob between # '”& dobto &"’ # and #’" & dobfrom &"’#;"
dobto and dobfrom is storing two different dates.
d_dob is Date Field
Error i get is…
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression ‘matri.d_dob between # ‘2/23/1973’ # and #‘2/23/1982’#’.
