topic Re: Problem in display the ReloadTime() in QlikView

Problem in display the ReloadTime()

Mon, 05 Nov 2012 16:44:23 GMT

In all my files I use a Text Object with the following formula:

='Fecha: ' & Date(ReloadTime(), 'DD MMM YYYY hh:mm')&'

So I can always see the date and hour of the last reloaded process. In QV 10 I had no problem at all, but with the upgrade to QV 11 (11.00.11414.0 SR2 64-bit Edition) I experiment a problem and cannot find a solution:

Durieng the same day of the reload, the date and time of the repoad is show correctly, but the next day of a reload , it show me the following value: Fecha: 30 Dic 1899 00:00

In version 10, I never experiment this problem. Have somebody have an explanation and solution? Thanks in advance for any help.

Pat.

Re: Problem in display the ReloadTime()

shree909 — Mon, 05 Nov 2012 17:54:20 GMT

i think reloadtime itself gives the the date and time , get rid of date function use reloadtime() that will give when u have reloaded ur application..

Re: Problem in display the ReloadTime()

Mon, 05 Nov 2012 18:30:46 GMT

Thanks, I will do the test and see if it works, will know tomorrow.

Re: Problem in display the ReloadTime()

its_anandrjs — Mon, 05 Nov 2012 18:32:56 GMT

Hi,

From my side you have to use only reloadtime( ) function no need for date function.

HTH

Regards,

Anand

Re: Problem in display the ReloadTime()

Tue, 06 Nov 2012 00:10:57 GMT

Well, it doesn't work eather!

With the formula as:

=ReloadTime()

it show me a Blank result after I close the aplication!

Any idea?

Re: Problem in display the ReloadTime()

erichshiino — Tue, 06 Nov 2012 14:59:35 GMT

Hi, This is strange.

Can you compare it with the result of a variable in script?

As the last line of your script, you can create the following variable:

vTestReload = now(1);

Then, on your interface, you can use this:

='Fecha: ' & Date(vTestReload), 'DD MMM YYYY hh:mm')

Hope it helps,

Erich

Re: Problem in display the ReloadTime()

Tue, 06 Nov 2012 15:15:44 GMT

Thanks Erish,

your solution work perfectly. I have to mention that this problem occur only on my personal files located on my computer, but all file in the server is working fine with my original formula.

Yes it is strange.

Patrick