Help with MS Query Date prompt format

[agtsrbt]

I'm just beginning to use SQL for MS Queries in Excel and am having difficulty with how to imput the date into a prompt.

I've used prompts for other fields and they seem to work fine, however, when I input the date in the query below in the following format YYYY-MM-DD, I get the following error:

"String length exceeds column length parameter #1.data truncated."

SELECT 
    ARInvoice.ShipTO_State, 
    ARInvoice.ShipTO_City, 
    ARInvoice.InvoiceNo, 
    ARInvoice.InvoiceDate, 
    ARInvoice.SalesAmt1, 
    ARInvoice.CreditAmount, 
    ARInvoice.DebitAmount, 
    ARInvoice.DiscAmount, 
    ARInvoice.SalesTax1Amt
FROM 
    ARInvoice ARInvoice
WHERE 
    (ARInvoice.InvoiceDate>?)
ORDER BY 
    ARInvoice.ShipTO_State

I've tried the following formats with the same error:

MM/DD/YYYY
MM/DD/YY
MM-DD-YYYY
MM-DD-YY
M/D/YYYY
M-D-YYYY
M/D/YY
M-D-YY

I'm querying a Sage BusinessWorks data base.

Can anyone help?

Thank you,

John