The SSRS MonthName function is a Date and Time function that returns the name of the month from the given DateTime as a String value from January to December. The MonthName function syntax to extract the month’s name from the Date information is as shown below.
=MonthName(5, True)
=MonthName( Month( Fields!OrderDate.Value), False)
To demonstrate the SSRS MonthName function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS MonthName function Example
Let me add a new column to the Hire Date column’s right side and name it the Month Name. Next, right-click the textbox under MonthName and choose Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.
It opens the following expression window to print Month names. The below SSRS MonthName function finds the name of the month for each employee from the HireDate column and returns string type from January to December.
=MonthName(Month(Fields!HireDate.Value))
Please click the preview tab to see the report. For more functions >> Click Here!
By default, the second argument is always set to True, so the code below returns the same result as the above example.
=MonthName(Month(Fields!HireDate.Value), True)
However, setting the SSRS MonthName function argument value to False returns the month names as Jan, Feb, .., and Dec. To show this, let me add a new column and write the expression below.
=MonthName(Month(Fields!HireDate.Value), False)
