How to get current month name in SSRS?

Question

I need current month name as default perameter name in my ssrs report. How can I get current month name using an ssrs expression?

For example "27-09-2012" would become "September"
and one more i need....

27-09-2012 to previous month name as well (August)

Answer 1

First question:

=MonthName(Month(Fields!datefield.Value))

Second question:

=MonthName(Month(DateAdd("m", -1, Today())))

I think the second question answer might be something like that, first converting the date to month then subtracting 1 from the month value and then converting it to month name.

Further reading:

• SSRS Reports get Month name from Month Index or from date
• Converting month number to month name in reporting services

OFF: I would change the date format you are using to 2012-09-27 as it works in every setting and should give you peace of mind when converting date formats.

Answer 2

Don't subtract 1 b/c it won't work for January. Use this: MonthName(Month(DateAdd("m", -1, CDate(Today))))

Answer 3

As a note, I tried the suggestion of =MonthName(Month(today())). What I would get is #error for whatever field the expression was in. However, =MonthName(str(Month(today()))) worked for me. I am unsure of whether or not the MonthName method changed to require a string or if it is some issue with my program. Just figured I would post this in case anyone else was having the same issue.

Answer 4

For Previous Month i found universal way : =MonthName(Month(CDate(Today()))-1,False) for SEPTEMBER (Full Month Name) 'OR' =MonthName(Month(CDate(Today()))-1,True) for SEP (Short Month Name)