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.
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)
Please click the preview tab to see the report. For more functions >> Click Here!
