9 Replies Latest reply on May 18, 2016 3:09 AM by Mahfooj Khan

    How to calculate number of days difference between sysdate date and a fixed date w.r.t sysdate

    Swapnil Bangad

      I have a query. In a formula i want number of days difference between 2 dates. 1st date is sysdate(Now()) and 2nd date would be 1st June( that has last passed).

      e.g If 1st date is  1/July/2015 than 2nd date should be 1/june/2015

          If 1st date is 1/Jan/2016 than 2nd date should be 1/June/2015.

       

          How do i calculate the second date?