SSRS Report Generation Date

The report generated date is one of the crucial headers or footers that must be included once the report has been designed.

Once a text box has been placed, right-click it, choose expression, and then type one of the following expressions.

=FORMAT(Cdate(today), “yyyy-MM-dd”)

=FORMAT(Cdate(today), “MM-dd-yyyy”)

=FORMAT(Cdate(today), “dd-MM-yyyy”)

=Format(Now(), “dd/MM/yyyy hh:mm tt”)

=”Report Generation Date: ” & FORMAT(Cdate(today), “dd-MM-yyyy”)

=”Report generation date: ” & Format(Globals!ExecutionTime,”dd/MM/yyyy h:mm:ss tt” )

=”Report Generation Date: ” & Today()

Hope this helps.