Hi

I am using crystal xi to produce invoices which display a due date. Most of my customers are on a 60 days from month end terms and I would like to display this on the invoice.

The current formula I am using is;

Dateadd('d',-(DAY(dateadd('m',1,dateadd('d',60,{sales_anal.invoice_date})))),dateadd('m',1,dateadd('d',60,{sales_anal.invoice_date})))

and this seems to work fine for all dates apart from the 1st of each month.

For example

When the invoice date is 01/07/2011 an incorrect due date of the 31/08/2011 is returned but for invoices dated the 02/07/2011 a due date of the 31/09/2011 is returned, which would be the correct date for both invoices.

Is there another formula i can use to prevent the 1st of the month anomaly?

Many thanks