The SSRS Day function is a Date and Time function that will extract the day of the month from the given DateTime and return an integer value from 1 to 31. The syntax of the Day function to extract the day of the month from the Date information is as shown below.
=Day(Fields!OrderDate.Value)
To demonstrate the SSRS Day function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS Day function Example
Let me add a new column to the right side of the Hire Date column and name it the Days. Next, right-click the textbox under Day and choose the 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 Days. The below Day function extracts the day of the month from the HireDate column and returns an integer value between 1 and 31 for each employee.
=Day(Fields!HireDate.Value)
Please click the preview tab to see the report. For more functions >> Click Here!
