SSRS Month Function

The SSRS Month function is a Date and Time function that will extract the month of the year from the given DateTime and return the integer value from 1 to 12. The syntax of the Month function to extract the month of the year from the Date information is shown below.

=Month(Fields!OrderDate.Value)

To demonstrate the SSRS Month function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.

Source Table

SSRS Month function Example

For this, let me add a new column to the right side of the Hire Date column and name it Months. Next, right-click the textbox under Month 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 Months. The below Month function extracts the month of the year from the HireDate column and returns an integer value between 1 and 12 for each employee.

=Month(Fields!HireDate.Value)
SSRS Month Function expression to return Month number from Date and Time Field

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

SSRS Month Function to return Month number from Date and Time Field preview