How to Create Monthly Trend Formulas in Crystal Reports

Resolution

1. To subtract one month from the current date use
   • DateAdd (“m”, -1, CurrentDate)
2. If you just want the month number use this
   • Month(DateAdd (“m”, -1, CurrentDate))
3. If you are trying to get the month name use this
   
   • MonthName(Month(DateAdd (“m”, -1, CurrentDate)))