In a MySQL table we have a DATETIME field AuditDate.

I want to pull records from that table for a specific date

ldDate = DATE()
=SQLEXEC(lnHandle,"SELECT * from mytable WHERE DATE(AuditDate) = ?ldDate")

Unfortunately, this pulls zero records. I know there are records for this date

ldDate = DATE()
=SQLEXEC(lnHandle,"SELECT AuditDate,DATE(AuditDate) ddd FROM myTable")
SELECT * FROM sqlresult WHERE TTOD(AuditDate) = ldDate ---> 171 records
SELECT * FROM sqlresult WHERE ddd = lddate ---> 171 records

Can someone give me the proper syntax for getting a MySQL datetime field using a parameter.

Muchly appreciated...............Rich