Crystal Reports 8.5; Formula for Conditional Message 1

[jrodrigues777]

HI!

New to writing crystal reports and I’m hoping someone could help me with a formula to accomplish the following.

I would like my accounts receivable invoices to print a past-due message on the invoice if I am reprinting the invoice 60 days or greater from the posted invoice date. i.e. invoice date 10/1/05, reprint 1/1/06 - message print: "past-due, pay up immediately".

Thank you in advance for your help!

 

[lbass]

Try something like:

if currentdate - {table.invoicedate} > 60 then
"Past due--please pay immediately."

If there can be multiple payments, you might need to change that to:

if currentdate - maximum({table.invoicedate},{table.invoice}) > 60 then
"Past due--please pay immediately."

-LB