topic Re: update date and time from a button in QlikView

update date and time from a button

Anonymous — Thu, 13 Nov 2014 15:48:45 GMT

Upon pressing the button I want that updates the date and time.

The only way that is updated by a partial reload of data.

in my textbox I have ='Última Actualización ' & timestamp(reloadtime())

what I want is to press the button and my box is upgraded

thanks for the support!!

Re: update date and time from a button

MarcoWedel — Thu, 13 Nov 2014 23:09:41 GMT

Hi,

maybe like this:

hope this helps

regards

Marco

Re: update date and time from a button

jduenyas — Fri, 14 Nov 2014 04:06:46 GMT

Instead of the TimeStamp(ReloadTime()) change that to Now()

Watch out not to use Today() because the date in today() also depends on reload and on restart of the application. If you leave your application running overnight and the next day you depend on functions that are dependent on Today(), your result will not be correct.

Now() is a dynamic function.

Re: update date and time from a button

jagan — Fri, 14 Nov 2014 04:29:59 GMT

Hi Josh,

ReloadTime() - Will gives you the last refresh timestamp of the Dashboard, if you use Now() you always get Current Date.

Hope this helps you.

Regards,

Jagan.

Re: update date and time from a button

sujeetsingh — Fri, 14 Nov 2014 05:00:11 GMT

You should use reload time .

Re: update date and time from a button

Anonymous — Fri, 14 Nov 2014 05:10:08 GMT

You want to update in database as well or just in UI ?

Re: update date and time from a button

mjm — Fri, 14 Nov 2014 09:41:00 GMT

Carlos you shouldn't be using reloadtime() as others have advised as this time is only updated when the document is reloaded. You should use the now() function instead.