The SSRS Now function is a Date and Time function that returns the current local date and time according to the system and returns the date value. The syntax of the Now function to print the current date and time is as shown below.
=Now()
To demonstrate the SSRS Now function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS Now function Example
For this, let me add a new column to the Hire Date column’s right side and name it Now. Next, right-click the textbox under Now and choose the 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 datetime. The below SSRS Now function prints the current system’s local date and time.
=Now()
Apart from the above, you can use the DateAdd, DateDiff, or DatePart functions to add, delete, and extract parts of the current date and time. To demonstrate this, add a new column and write the expression below. It adds seven years to the current system’s local date and time.
=DateAdd("yyyy", 7, Now())
Please click the preview tab to see the report. For more functions >> Click Here!
