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 SSRS 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 charts, tables, grouping, and format tables in SSRS.
It opens the following expression window to print the present date. The SSRS Today function below prints the system’s current local date.
=Today()
Apart from the above, you can use the DateAdd, DateDiff, or 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 DateDiff will find the difference between the current system date and the Hire Date column.
=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. For more functions >> Click Here!
