Wednesday, April 18, 2012

subtract one month from the current date crystal report

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

No comments:

Post a Comment