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
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