Select con date SQL Server

[Mems]

mydate = "2005-10-31"
sql = "... WHERE CONVERT(CHAR(10), campoData, 121) = '" & myDate & "'"