Sage 100

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.

AR Invoice History Report - Dates (Crystal Reports)

Posted By JRoth 12 months ago

Hi All,

I have a report that is using the {AR_InvoiceHistoryHeader.InvoiceDate} field and I need it to return the last 18 months of data. Does anyone know the proper syntax to do this. Something along the lines of:

"{AR_InvoiceHistoryHeader.InvoiceDate} = Last18Months"

Thanks!

Top Replies

BShockley 12 months ago +2

The record selection formula for exactly 18 months from the current date is as follows:

{AR_InvoiceHistoryHeader.InvoiceDate} >= dateadd("m",-18,currentdate)

0 BShockley 12 months ago

The record selection formula for exactly 18 months from the current date is as follows:

{AR_InvoiceHistoryHeader.InvoiceDate} >= dateadd("m",-18,currentdate)
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 JRoth 12 months ago in reply to BShockley

Perfect, thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

AR Invoice History Report - Dates (Crystal Reports)

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING