Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…