Discussion board where members can get started with Qlik Sense.
I wanted to subtract between dates and the result should be in days.
The data in my excel is
payment_start_date = 01-11-2017
payment_end_date = 30-04-2018
I used the lines that I have found in one the forums.
Interval(((Date#([PAYMENT_END_DATE], 'DD-MM-YYYY'))-Date#([PAYMENT_START_DATE], 'DD-MM-YYYY'))) AS DURATION
But the duration came out not the way I wanted , I have attached the picture.
I need some help as I am quite new with this.
May be this?
This is a good option, but if all the OP needed is number of days, I would just do this without Interval function
Date#([PAYMENT_END_DATE], 'DD-MM-YYYY') - Date#([PAYMENT_START_DATE], 'DD-MM-YYYY') as DURATION