Search Date Field Issue

[theflyingminst]

Hi I'm trying to search a date field in Access 2007 with classic ASP and the records in the database are not pulling up for some reason.

Is this the correct syntax?

strSQL = "SELECT * FROM calendar WHERE cal_date LIKE " & goDate


Thanks so much

[yamaharuss]

try enclosing the date...

strSQL = "SELECT * FROM calendar WHERE cal_date = '" & goDate & "' "

I don't believe you can use LIKE in your query

[theflyingminst]

That worked! Thanks so much Yamaharuss!