topic Re: ADD and SUBTRACT Time in QlikView

ADD and SUBTRACT Time

rustyfishbones — Mon, 11 Nov 2013 11:43:06 GMT

In Qlikview you can use ADDMONTHS and ADDYEARS to subtract or add months and years

Is there a similar function for time?

regards

swuehl — Mon, 11 Nov 2013 11:46:14 GMT

Time and date are numbers in QlikView, just the text part is formatted accordingly.

So you can use maketime() etc, to create a time value (or just enter the number in fraction of days) and use arithmetic operations + and -.

jonathandienst — Mon, 11 Nov 2013 11:57:08 GMT

Remember that time is the fractional part of the datetime number. So 0.25 = 06:00 when formatted as time.

As swuehl said, its just simple arithmetic, so

To add 1 hour, add 1/24

To add 1 minute, add 1/1440

HTH

Jonathan