How to show last data refresh time on the sheet?

[#1]

Is there a system variable available which I can use to show the last data refresh time for a sheet or for a complete document or I need to create a new vaiable for that?

Thanks,

TA

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Yes, use

ReloadTime()

That will return the last time the document was reloaded.

Hope that helps.

Miguel

[#3]

Hi,

There is ReloadTime() function,

Regards,

Yigal.

[#4]

I got the refresh date and time, but it is showing me the date and time for Septmber 13th and today its 17th.

Why it is not shoiwng me the today's date?

Is it because of when the QVD last time cretaed or refreshed?

Thanks,

[#5]

Hi,

As Miguel wrote: "...That will return the last time the document was reloaded."

The document meens youre QVW file.

Yigal.

[#6]

Got it. Thank you very much guys 🙂

[#7]

We get SAP tables each night and we want to know the time stamp of the file. To get this use:

Load  filetime() as FileTimeStamp from 'Q:\FolderName\FileName.QVD';

Stephen

[#8]

If I want to add some text before that e.g "Last Update:" before the time stamp, what can I write?

I wrote  "='Last Reload: ' &ReloadTime()" and it worked but it is giving me the

time in the following format: 18/09/2012 08:43:15

where as I want this in the following format: 2012-09-18 08:43:15

How can I change the format of time?

Thanks,

TA

[#9]

Number of ways, but one way is to go to "Setting", "Document Properties","Number", select the field and format it the way you want.

Stephen

[Anonymous]

HI Miguel,

I use the same ReloadTime () command to show the date and time, but I need to record all those times the application was updated. It's possible?