hi

I am unable to execute this code on my ASP page.The error is
Type mismatch getdate.I am using SQL server.

Earliar I had used access than now() for current date is working perfectly OK.

if Request.Form("searchdate") <> 0 then
dt = cint(Request.Form("searchdate"))
StrSql = StrSql & "T_date > " & dateadd("d", "-dt", getdate()) & ") and ("
End if