"A month number must be between 1 and 12" error in formula
Posted on 2008-10-27
I've created a report that will run for the last twelve months based on the current date (a rolling 12 month report).
I'd like to make some corresponding labels for the month values. I was using this:
monthname (Month (CurrentDate), True)
monthname (Month (CurrentDate) - 1, True)
and it was working great until I got to month - 10. Then I got this error:
A month number must be between 1 and 12
Any ideas? Is there another way to accomplish my goal? Also, I have to keep the labels short for space consideration which is why I need "Oct" instead of "October".
Thanks in advance,