How to retrieve current month in SSRS expression?

Question

I want to get current month as default value of a parameter. I've come up with (which does not work): =Month(Now())

Answer 1

Hello,

To get the name (string, ex. August) of the current month use:

=MonthName(Month(Today()))

If you wanted to return just the number (int between 1 and 12, ex. 8) of the current month use:

=Month(Today())

For addition reference you can check out this site for other SSRS expressions:

https://pragmaticworks.com/portfolio/ssrs-expressions-cheat-sheet/