Help with adding minutes to timestamp

[#1]

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

[Pulkit_Thukral]

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.

[sunny_talwar · Accepted solution]

You can try this:

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

[#4]

Thank you Pulkit!!

[#5]

This worked! Thank you Sunny!

[sunny_talwar]

Awesome