Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nurmahirahaqila
New Contributor

Calculate Date Subtraction

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.

Tags (2)
2 Replies

Re: Calculate Date Subtraction

May be this?

=Interval(Date(Date#(PAYMENT_END_DATE, 'DD-MM-YYYY'))-Date(Date#(PAYMENT_START_DATE,'DD-MM-YYYY')),'DD')

Life is so rich, and we need to respect to the life !!!

Re: Calculate Date Subtraction

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

Community Browser