The SSRS Today function is a Date and Time function that returns the current local date only according to the system and returns the date value. By default, the text box returns the current date and sets the time to midnight. The syntax of the Today function to print the present date is as shown below.
=Today()
To demonstrate the Today function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS Today function Example
For this, let me add a new column to the right side of the Hire Date column and name it Today. Next, right-click the textbox under Today and choose Expression. To understand the report, I suggest you refer to the articles on SSRS charts and SSRS Dashboard reports from our SSRS tutorial page.
It opens the following expression window to print the present date. The Today function below prints the system’s current local date.
=Today()
Apart from the above, you can use the SSRS DATEADD, DATEDIFF, or SSRS DATEPART functions to add, delete, and extract parts of the current date. To demonstrate this, add a new column, Year Diff, and write the expression below.
The SSRS Today Function and SSRS DATEDIFF will find the difference between the current system date and the Hire Date column. To format the date and time, use the SSRS FORMATDATETIME function.
=DateDiff(DateInterval.Year, Fields!HireDate.Value, Today())
Please click the preview tab to see the report. The image shows that it sets the time value to midnight. To return the date (only), please change the text box properties from default to Date. Go to the Text Box properties -> Number -> Date -> Choose the Type.
TIP: Please refer to the SSRS NOW method from the list of available SSRS Date and time functions.
