topic Re: Function Reload Time() in QlikView

Function Reload Time()

Wed, 05 Mar 2014 17:02:25 GMT

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!!!

Re: Function Reload Time()

chiru_thota — Wed, 05 Mar 2014 17:05:30 GMT

try this

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

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

Re: Function Reload Time()

Colin-Albert — Wed, 05 Mar 2014 17:05:35 GMT

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

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

Re: Function Reload Time()

Wed, 05 Mar 2014 17:22:13 GMT

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!!

Re: Function Reload Time()

chiru_thota — Wed, 05 Mar 2014 17:24:34 GMT

Hi Omar,

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

Re: Function Reload Time()

MK_QSL — Wed, 05 Mar 2014 17:26:41 GMT

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

Re: Function Reload Time()

Colin-Albert — Wed, 05 Mar 2014 17:31:07 GMT

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?

Re: Function Reload Time()

Anonymous — Wed, 05 Mar 2014 17:37:36 GMT

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.

Re: Function Reload Time()

Wed, 05 Mar 2014 17:41:14 GMT

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

Re: Function Reload Time()

swuehl — Wed, 05 Mar 2014 17:42:31 GMT

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

Let vReloadTimeGermany = localtime('Berlin');

Re: Function Reload Time()

Anonymous — Wed, 05 Mar 2014 17:44:38 GMT

did my post not help? that is exactly what the expression in my post does! just make sure you have the time difference between server and Germany in days as i stated.

Re: Function Reload Time()

Colin-Albert — Wed, 05 Mar 2014 17:50:57 GMT

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

Re: Function Reload Time()

Wed, 05 Mar 2014 18:22:16 GMT

Hi jsaradhi its Perfect and almost correct your response just I am not was explicit the hour is in Germany but Amsterdam time zone rally I apologize with you. really thanks for your help !!!!

Re: Function Reload Time()

Wed, 05 Mar 2014 18:24:46 GMT

Tanks Colin Albert work it perfect the formula is helpful and actually I use this formula in my program.

Regards!!!!

Re: Function Reload Time()

Anonymous — Wed, 05 Mar 2014 18:27:14 GMT

no big deal...i'm glad you got it figured out. the time difference can be modified to what ever the time difference is.

Re: Function Reload Time()

Wed, 05 Mar 2014 18:30:59 GMT

Hi jsaradhi but the way you all right, how I can move exactly the hour with your formula? for example one hour more.

Re: Function Reload Time()

Anonymous — Wed, 05 Mar 2014 18:46:23 GMT

6/24=0.25...so for x hour time difference, it would be x/24...so if you need 7, it is 7/24...simple!

Re: Function Reload Time()

Wed, 05 Mar 2014 18:56:34 GMT

i test what you mean thanks for your help regards!!!

Re: Function Reload Time()

swuehl — Wed, 05 Mar 2014 20:32:01 GMT

Just take care that US and Germany don't switch to DST on the same date (if you care about Daylight Saving Time at all).