Type Mismatch

[JDU]

strSQL = "Select * from tblHns where Datediff('d'," & txtDate & ",[Date]) >=30"
Set rstHns = dbs.OpenRecordset(strSQL)

I get an error of type mismatch

The field Date is of type Date/Time and format of Short Date

The field txtDate is a textbox on a form with a format of Short Date.

Please help, Thanks.

 

[Golom]

Access usually needs some explicit specification about date fields entered as text fields. Try

strSQL = "Select * from tblHns where " & _
         "Datediff('d', [COLOR=red]#[/color]" & txtDate & "[COLOR=red]#[/color],[Date]) >=30"

 

[JDU]

Thanks, but I still get the same type mismatch error.

 

[JDU]

Figured out what my error was. Thanks.