Hello Everyone, 

I am attempting to put together this ODBC query against the Sage database, and I am trying to return values from the past year, specifically using this parameter:

WHERE AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL 12 MONTH)

This is failing, 

Here is the entire query:

select

AR_InvoiceHistoryHeader.InvoiceNo,

AR_InvoiceHistoryHeader.InvoiceDate,

AR_InvoiceHistoryDetail.ItemCode,

AR_InvoiceHistoryDetail.QuantityShipped

FROM AR_InvoiceHistoryHeader, AR_InvoiceHistoryDetail, AR_Customer, ar_division

where ar_invoiceHistoryHeader.arDivisionNo=ar_division.ARDivisionNo and (AR_InvoiceHistoryHeader.HeaderSeqNo = AR_InvoiceHistoryDetail.HeaderSeqNo) AND (AR_InvoiceHistoryHeader.InvoiceNo = AR_InvoiceHistoryDetail.InvoiceNo) and (AR_InvoiceHistoryHeader.CustomerNo = AR_Customer.CustomerNo) AND (AR_InvoiceHistoryHeader.ARDivisionNo = AR_Customer.ARDivisionNo) AND AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL 12 MONTH)

Thanks for any advice you may be able to provide.

--Matt