Database Refresh Time-stamp on Document

[#1]

I would like to include a text box object on each document that lets users know when the last refresh was of the data they are working with. How would I pull this information and place it on document sheet?

Thanks for any insight!!

Rob

[giakoum · Accepted solution]

As off date : '  & TIMESTAMP(RELOADTIME())

[#3]

Thanks - this worked for me!

[giakoum]

Please Rob close this discussion as Answered.

Thank you.

[#5]

Two things here,

1.Database Refresh time

This specific to the data and nothing to do with QV application where the database has been last refreshed. This can be achieved by taking the max of the Updated Date field (a field that should be available in your fact tables or you should having some 'run info' table or any table, table name may be different where they store the last successful runtime or execution time of the database)

Load this table as an island table into QV and,

Let vLastUpdatedDate= max(updateddate)

use this in ur text obj ='Data last refreshed date :' & $(vLastUpdatedDate)

2.QV Reload Time

='Data as of :' & QvReloadTime(), as suggested in the above post

should work