SSRS TimeValue Function

The SSRS TimeValue function is a Date and Time function that takes the time information from the given DateTime and sets the date value to January 1, 0001. The syntax of the TimeValue function to set the date value to January 1, 0001, is as shown below.

=TimeValue(Fields!StartDate.Value)
=TimeValue("10:45:51")

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

Source Table

SSRS TimeValue function Example

For this, let me add a new column to the right side of the Hire Date column and name it the TimeValue. Next, right-click the textbox under TimeValue 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 set the date to the starting point. The TimeValue function below extracts the time information from the HireDate column and sets the date value to January 1 of year 0001 for each employee.

=TimeValue(Fields!HireDate.Value)
SSRS TimeValue Function  expression to return the time value from DateTime and date as January 1, 0001

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

SSRS TimeValue Function   to return the time value from DateTime and date value as January 1, 0001 preview