I have a MySql table with a DateTime field. I want to get all the records for today.

ldDate = DATE()
=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE dtField = ?ldDate")

This produces no records, which is expected since I'm not accounting for the time portion of the field. But when I tried

=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE DATE(dtField) = ?ldDate")

I also got no records back. When I tried

ldDate = DATE()
lcDate = TRANSFORM(DTOS(ldDate),"@R 9999-99-99")
=SQLEXEC(lnHandle,"SELECT * FROM myTable WHERE DATE(dtField) = ?lcDate")

I got the records I wanted.

Could somebody tell me why passing a Date value doesn't work while passing a character representation of the date does work?

Thanks............Rich