Pass Thru Query Data Parameter Syntax

S

Shea Schultze

I'm using Access 2003 and QuickBooks Enterprise 7.0. I've got a pass thru
query that works fine until I attempt to request a date.

SELECT *
FROM InvoiceLinkedTxn
WHERE IsPaid = 0 and TxnDate = #6/20/06#

I've tried variations of the date formats MM/DD/YYYY and YYYY-MM-DD and
YYYYMMDD. I've tried using # and ' and " and [ and ( and { but to no avail.

Can you assist?
 
Top