Hi. I have the latest versions of the driver and QuickBooks
Enterprise 7. I use Access 2003. Pass Thru queries work just great
until I try to restrict by date.

This works perfect:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE ClassRefFullName = "001-Gfeller"

This fails:
SELECT *
FROM InvoiceLine UNOPTIMIZED
WHERE TxnDate = ????!!!!????

I've tried different bracketing:
(), {}, [], " ", ' ', ##
I've tried different date formats:
YYYY-MM-DD, YYYY-DD-MM, YYYYMMDD, MM/DD/YY, MM/DD/YYYY, etc.

Got a variety of different error messages like Unexpected Literal,
or etc.

Any suggestions?