hello all

thanks for your help so far



have a new problem, and im sure its just general frustration getting to me.



to get the code to work i had to add # signs to tell it to look for a date,

but now it works, but i dont get any returns on my search.



any ideas.



btw the new code looks like this



If Request.Form("status") = "pendweek" Then

	Set WO = Server.CreateObject ("ADODB.Recordset")

	Query = "SELECT * FROM WorkOrders WHERE Pending_due<=#" &

DateAdd("d",7,Date())& "# ORDER BY ID"

	WO.Open Query, Connect

End IF



thanks again

/john