4/7/2003 vs 04/07/2003 1

[Zirak]

Hi,
I have a parameter query in SQL. The Query selects records in a date range based on the parameters.

my problem is that if I put the dates in the format of 4/7/2003 it won't work and I have to insert the date like 04/07/2003.

I don't know how to fix this. Its important since the parameters are coming froman Access ADP front end through the calendar object which saves the date in the 4/7/2003 format.


Thanks

 

[bjd4jc]

Is your field stored as a date field or a text field? if you are storing it as text you will encounter this problem. Check to see what the data type on the field is.

 

[Zirak]

Thanks
The problem was the Data type.