Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem in display the ReloadTime()

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.

1 Solution

Accepted Solutions
erichshiino
Partner - Master
Partner - Master

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

View solution in original post

6 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

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

its_anandrjs

Hi,

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

HTH

Regards,

Anand

Not applicable
Author

Well, it doesn't work eather!

With the formula as:

=ReloadTime()

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

Any idea?

erichshiino
Partner - Master
Partner - Master

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

Not applicable
Author

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