Subtract Month Crystal Report

If you have a date field and wish to derive the previous month from that date, use the formula below.

DateAdd ("m", -1, CurrentDate)

This Is particularly useful for Prior Month Calculation.

 

Obviously you can adjust the -1 value to calculate any number of months previous. i.e to identify 12 Months Prior from a particular date you would use the formula

DateAdd ("m", -12, CurrentDate)

CurrentDate can also be replaced by whichever date field you require.