Add seconds

[#1]

Hi there

I have a problem in using time function in qlikview; assume that i have a variable that keeps Num of  now time in itself.I need to add 1 second to this number and again convert it to time format.which number can add one second to the number?

[marcus_malinow]

Well,

given that under the hood QlikView stores each date as a floating point number, and there are 86400 seconds in a day

just add 1/86400 to your time

Marcus

[sunny_talwar · Accepted solution]

Or you can add like this:

Time(FieldName + MakeTime(0, 0, 1))

[#4]

Tnx a lot.

works properly