Date compare failure!!!

[hombre_de_las_ca]

i have a variable called newvalue1 which contains a date such as
newvalue1 = request.form("tf1")
where tf1 is the date sent from the previous page in the format 4/5/2005
now when i give the following statement it gives an error

objrs.find ("date") < newvalue1

"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

also if i give

objrs.find ("date") = newvalue1
i get a " type Mismatch" error

any thing wrong???
CaveMan

[Thing]

You are comparing a date data type to a non-date data type. Try this:

newvalue1 = CDate(request.form("tf1"))
If objrs.find ("date") < newvalue1 then
 'blah
End if

That is assuming objrs.find("date") is a date data type.

[hombre_de_las_ca]

Thanks a lot....had been giving the date to the sql statements as # date #
and it always worked... never thought of checking the data type...

[Thing]

"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

If you ever get this error then check datatypes.