Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Function Reload Time()

Hi everyone;

Actually when I Update a Dashboard I use the  ReloadTime function to know when the information was updating

and I need the same with the Date, hour, minutes and seconds BUT for Germany i was try that but i cant do it can you help please?

i was try this:

Date(ReloadTime())&'   '&Time(ReloadTime())

Any IDEA?

regards!!!

1 Solution

Accepted Solutions
Colin-Albert

Add an offset for +7 hours the time difference to Germany.

= 'Updating Date   ' & Date( (reloadtime() +(7/24)), 'DD-MM-YYYY  hh:mm')

(7/24) adds 7 hours to the reloadtime

View solution in original post

18 Replies
chiru_thota
Specialist
Specialist

try this

= 'Last refreshed on - ' & ReloadTime() &'  '&TimeZone()

Out put : Last refreshed on - 8/15/2013 9:34:18 AM  GMT-06:00

Colin-Albert

Use date(reloadtime(), date format string)  The date command will format datetime values

e.g. date(reloadtime(), 'DD MMM YY  hh:mm')

Not applicable
Author

I every one thanks for your responses but doesn't work actually the server is in USA and

the Date hour, minutes and seconds with the ReloadTime() or TimeZone() put the Dates but USA

i need that appear the date and hour, minutes and second  but Germany.

Any Idea?

Really Thanks!!

chiru_thota
Specialist
Specialist

Hi Omar,

Can you give exact format/Example in what you wanted in Germany ?

MK_QSL
MVP
MVP

='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(OSUser())

Colin-Albert

The dateformat string is case sensitive

     MM      is months as a number

     MMM      is months as text

     mm      is minutes

what result do you get if you do not have any formatting and just use

     = reloadtime()

in a text object?

Anonymous
Not applicable
Author

if i understand this correctly, you need server reload time shown as local time in Germany...if yes, try the following - may need to be modified slightly for time difference:

='Server Time '& chr(10)&ReloadTime() & chr(10)&TimeZone()

For local time in Germany -

='Local Time '&chr(10)&Timestamp(ReloadTime()+.25)

0.25 days (6 hours) is the time difference between your server time and Germany local time.

Not applicable
Author

Hi everyone this the format that I have:

Is the time in United States, when I was updating put the Date hour, minutes and Second but

of United State. then what I need is the same BUT with date, hour, minutes for Germay

for example taken this example the date in USA is: 05/03/2014 11:04:45 AM and

what I need is: 05/03/2014   18:40:30  time Germany

Time.jpg

swuehl
MVP
MVP

Maybe create a variable at the end of your load script:

Let vReloadTimeGermany = localtime('Berlin');