topic Help with adding minutes to timestamp in QlikView

Help with adding minutes to timestamp

Thu, 21 Apr 2016 17:24:48 GMT

Hello everyone,

I am having trouble adding minutes to the "Reloadtime()" timestamp in QlikView. I started with the formula below to see if I could add four minutes to my reload time but instead of moving it from 5:28 to 5:32 it moved it to 5:04 for some reason. What am I doing wrong? Is there a better way to do this? Thank you in advance for your help!

=date(Reloadtime()+maketime(0,0,0),'MM/DD/YYYY HH:MM tt')

If I had gotten that formula to work, my next step was to create a variable and use it in the minute place of the maketime formula.

=date(Reloadtime()+maketime(0,$(vMinutes),0),'MM/DD/YYYY HH:MM tt')

Re: Help with adding minutes to timestamp

Pulkit_Thukral — Thu, 21 Apr 2016 18:06:26 GMT

Hi Colter ,

Please find answer to your first query below :

To add 4 minutes to reload time ,use following expression :

=date( ReloadTime() + Time#(4,'mm') ,'MM/DD/YYYY hh:mm tt')

Please revert in case of any issue.

Re: Help with adding minutes to timestamp

sunny_talwar — Thu, 21 Apr 2016 18:18:29 GMT

You can try this:

TimeStamp(ReloadTime() + ($(vMinutes)/(24*60)))

Re: Help with adding minutes to timestamp

Thu, 21 Apr 2016 18:46:00 GMT

Thank you Pulkit!!

Re: Help with adding minutes to timestamp

Thu, 21 Apr 2016 18:46:17 GMT

This worked! Thank you Sunny!

Re: Help with adding minutes to timestamp

sunny_talwar — Thu, 21 Apr 2016 19:17:37 GMT

Awesome