How do you say...<BR><BR>select * from table where mydate before date
select * from table where mydate < date <BR>
It's not supporting that request...<BR><BR>My dates are an NvarChar in SQL and they are setup as 1/22/2003.
... where mydate < '" & date & "'"
Well, as nVarChar, you need to convert them to DateTime using the CONVERT Command.<BR><BR>Select * from table where CONVERT(datetime, myDate, 101) < getDate()<BR><BR>