I am trying to write some very straight forward code. Searching for all records between a certain date. This is my code:
select * from SALES_STAFF
where DATE_HIRED between date('11/3/96 12:00AM') and date('8/18/1997 12:00AM')
And I get an error about the arguments I am trying to pass. Is there something wrong with the date function I am using?
Error number -239:
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.
[Microsoft][ODBC Microsoft Access Driver] Wrong number of arguments used with function in query expression 'DATE_HIRED between date('11/3/96 12:00AM') and date('8/18/1997 12:00AM')'.