How to display the previous month as text without DateAdd?

[stormtrooper]

I may be missing something really easy here (blanking out maybe), but how do you display the previous month as text?

So I want to somehow turn this:

month(currentdate)-1 (which equals 6.00)

to:

June

 

[stormtrooper]

Sorry, using CR7.

 

[oneilltnc]

MonthName(Month(CurrentDate) - 1)

 

[stormtrooper]

I don't have the MonthName function.

 

[oneilltnc]

You could do it this way as well. Create a formula like this if you don't have monthname.

IF MONTH(CURRENTDATE)-1 = 6 THEN
"June"
ELSE IF
MONTH(CURRENTDATE)-1 = 7 THEN
"July"
ELSE IF
MONTH(CURRENTDATE)-1 = 8 THEN
"August"

You would do this for all 12 months and that should work as well.

 

[stormtrooper]

Got it, I knew I've done this before.

totext(date(year(currentdate), month(currentdate) - 1, day(currentdate)), 'MMMM')

 

[synapsevampire]

From the CD whitepaper:

http://support.crystaldecisions.com/library/kbase/articles/c2007194.asp

StringVar Array X:= ["January", "Febuary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
Numbervar Y:= Month(currentdate) - 1;
X[Y];

-k