I'm trying to search for all records with dates in a specified Month. I am assigning the month name to a variable and then trying to use the variable in the SQL statement. Lets say Request.QueryString("month") = 02/04/02. The monthName function in this example would assign April to the variable myMonth.<BR><BR>myMonth = monthName(Month(CDate(Request.QueryString("month") )))<BR><BR>My SQL statement is:-<BR><BR>sql = "SELECT Name, [Return Date] FROM tblStaff WHERE [Return Date] = '"& myMonth &"' "<BR><BR>However, my dates in the database are stored in Short Date format. e.g. 01/04/02 etc.<BR><BR>Can you see what i'm trying to do? I presume this will produce a data mismatch error as it tries to compare a month name with a short date. How can i solve this problem?