Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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),'.',' '))
use
ReloadTime() function
Use ReloadTime() function
use qlikview function ReloadTime()
hi,
use reload time() function
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),'.',' '))
Now(0) is also a possibility
Fabrice
Hi Luis,
Try this:
='[ Updated at
' & timestamp(reloadtime(), 'hh:mm on
MMM DD, YYYY') &' ]'
Is there a way to get AM or PM on the timestamp?
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