Wrong number of arguments

Dev Shed Forums Sponsor:

May 17th, 2012, 12:19 PM

rbon4

Registered User

Join Date: May 2012

Posts: 5

Time spent in forums: 1 h 35 m 32 sec
Reputation Power: 0

Wrong number of arguments

Hello,

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')'.

Thank you!

-rbon4

May 17th, 2012, 12:37 PM

Vomster

Contributing User

Join Date: Feb 2005

Posts: 724

Time spent in forums: 1 Week 3 Days 2 h 26 m 31 sec
Reputation Power: 290

Try this

Code:

select * from SALES_STAFF
where DATE_HIRED between '11/3/96 12:00AM' and '8/18/1997 12:00AM'

May 17th, 2012, 12:50 PM

rbon4

Registered User

Join Date: May 2012

Posts: 5

Time spent in forums: 1 h 35 m 32 sec
Reputation Power: 0

I tried that and it gives me a mismatched data type error.

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

Thoughts?

May 17th, 2012, 01:05 PM

Vomster

Contributing User

Join Date: Feb 2005

Posts: 724

Time spent in forums: 1 Week 3 Days 2 h 26 m 31 sec
Reputation Power: 290

Not too sure.

Check out this.
http://www.techonthenet.com/sql/between.php

May 17th, 2012, 01:55 PM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 26,357

Time spent in forums: 3 Months 1 Week 2 Days 4 h 40 m 42 sec
Reputation Power: 4140

try this

Code:

SELECT something
     , anything
     , just_not_the_dreaded_evil_select_star 
  FROM sales_staff
 WHERE date_hired BETWEEN #1996-11-03# AND #1997-08-18#

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

May 17th, 2012, 02:11 PM

rbon4

Registered User

Join Date: May 2012

Posts: 5

Time spent in forums: 1 h 35 m 32 sec
Reputation Power: 0

YES

It works! Thanks for your help guys

Wrong number of arguments

Developer Shed Advertisers and Affiliates