How to Create Monthly Trend Formulas in Crystal Reports ResolutionTo subtract one month from the current date useDateAdd (“m”, -1, CurrentDate)If you just want the month number use thisMonth(DateAdd (“m”, -1, CurrentDate))If you are trying to get the month name use thisMonthName(Month(DateAdd (“m”, -1, CurrentDate))) Crystal Reports Request Support