How do I add the date of refresh on the report? Currently I manually go and
add the date in the report.

Now() doesn't work, as it shows the current date.

Basically all I am looking for is, when someone goes and opens a report, it
should display the last date the report refreshed.

Any help is appreciated!