Calculate Date Subtraction

[Anonymous]

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.

[Anil_Babu_Samineni]

May be this?

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

[sunny_talwar]

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