2 Replies Latest reply: Jan 8, 2018 7:14 AM by Sunny Talwar RSS

    Calculate Date Subtraction

    Nur Mahirah Aqilah

      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.