Looking at this:

WHERE Date_Paid Like '%" & monthdate & "'

Would indicate Date_Paid is not a date data type. Have you made this field a string?

Wind is your friend
Matt
www.elitemarquees.com.au

Yes, When you select a month and year from my pulldowns from the form page, it returns a string "date_test.asp?monthdate=04&yeardate=2007" for example.

If as I suspect Date_Paid is you database field name - Have another read of my question.

Its obvious the Querystring passes a string, my question refered to the data type of your database field. Hopefully you have stored this as a date type and not a string?

Wind is your friend
Matt
www.elitemarquees.com.au

Yes, my date field is set as a "DATE" field not as a "VARCHAR"... after endless searching and having issues with the search function only searching the day and year, I have found to sue this to resolve the reversed MySQL YYY-MM-DD issue as well...

SQL =" SELECT * FROM unsolved WHERE date_FORMAT(Date_Entered, '%m') Like '%" & monthdate & "' and date_FORMAT(Date_Entered, '%Y') Like '" & yeardate & "%' and State Like 'Declined%' ORDER BY Date_Entered ASC ;"

works like a charm now!