ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add Refresh date (https://www.excelbanter.com/excel-discussion-misc-queries/84849-add-refresh-date.html)

Sue

Add Refresh date
 
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!

Ron Coderre

Add Refresh date
 
What is the source of the report?
If it is an on-demand query, can you add a date/timestamp field that can be
incorporated into the report?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Sue" wrote:

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!



All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com