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.