Last Month as just month Name

[ndeeleysww]

Hi,

I'm setting some variables in my load script to bring back month names:

SET tThisMonth = Month(Today());

SET tLastMonth = Month(Today())-1;

However, whilst the first variable returns Apr, the second returns 3. I need this variable to be just the month name, as the data I am evaluating has the amount in one column and the month name for that amount in the next. I've tried MonthName but this also returns the year.

Any help gratefully received!

Cheers

Neil

[jsanchezh]

Maybe you can try this

month(month(today())-1)

Kind Regards

[#3 · Accepted solution]

Try this..

Month( AddMonths(Today(),-1))

[ndeeleysww]

That worked! Thank you.

[ndeeleysww]

Sorry - that just returned Jan

[anuragprasad]

You can also try :

Date(Addmonths(today(), -1), 'MMM') for Month name or

Date(Addmonths(today(), -1), 'MMM-YY') for MonthYear