SSRS MonthName Function

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.

Source Table

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.

Choose Expression option

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.

SSRS MonthName Function expression to return name of the month

Please click the preview tab to see the report. For more functions >> Click Here!

SSRS MonthName Function to return name of the month preview

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)
SSRS MonthName Function to return month names as January, December preview