I get this error ("Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting DATETIME from character string.") in a remote view with the following code. ldDate is equal to '%'. Seems simple enough but here we go again. Can anyone help?

SELECT *;
FROM dbo.Test Test;
WHERE Test.date1 = ?lddate