SSRS Minute function

The SSRS Minute function is a Date and Time function that will extract the Minute of the hour from the given DateTime and return an integer from 0 to 59. The syntax of the Minute function to extract the Minutes from the Time information is as shown below.


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

Source Table

SSRS Minute function Example

For this, let me add a new column to the right side of the Hire Date column and name it the Minutes. Next, right-click the textbox under Minute and choose Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.

Choose the expression option

It opens the following expression window to print Minutes. The below Minute function extracts the Minute of the hour value from the HireDate column and returns an integer value from 0 to 59 for each employee.

SSRS Minute Function expression to return Minute of the hour from date and time field

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

SSRS Minute Function to return Minute of the hour from date and time field preview