Archive for November, 2011
Subtract Month Crystal Report
November 11, 2011
Leave a comment
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.
Categories: Crystal Reports