How to show last update moment in a text box

[#1]

Hi,

I wonder if there is a way to show in a text box (for example) the moment the the script was lauched for the last time so the data updated.

Any idea please?

Thanks

[ashwanin]

use

ReloadTime()  function

[alexandros17]

Use ReloadTime() function

[manojkulkarni]

use qlikview function ReloadTime()

[vipin_mishra479]

hi,

use reload time() function

[MK_QSL · Accepted solution]

Use this in text box...

='Last Updated '&Date(ReloadTime())&CHR(10)

&Hour(NOW()-ReloadTime())&' Hour(s),'&CHR(10)

&Minute(NOW()-ReloadTime())& ' Minute(s) and'&CHR(10)

&Second(NOW()-ReloadTime())& ' Second(s) ago' & CHR(10)&

'By '&Capitalize(Replace(SUBFIELD(OSUser(),'\',2),'.',' '))

[#7]

Now(0) is also a possibility

Fabrice

[amit_saini]

Hi Luis,

Try this:

='[ Updated at

' & timestamp(reloadtime(), 'hh:mm on

MMM DD, YYYY') &' ]'

[#9]

Is there a way to get AM or PM on the timestamp?

[amit_saini]

Check this:

Suppose , 'T' in your timestamp format will be translated to either 'P' or 'A' as part of 'TT' resp. 'PM','AM'.

I think you can create your own format while keeping the numeric representation using dual() function:

[assuming a TimeStamp TS with a valid numeric representation]:

LOAD

     TS,

     dual( Date(TS,'YYYY-MM-DD') &'T' & time(TS,'hh:mm:ss'), num(TS) ) as MyTimeStamp,

Thanks,

AS