3 Replies Latest reply on Sep 14, 2018 9:24 PM by Gavin Wong

    Datediff in years

    Gavin Wong

      Hi team


      this is baffling me. i created a simple datediff calculated field to get the difference in years between the max order date and the order date.

      attached is the workbook.


      using the max date - start date i should get a positive number, why is it showing negative ?

      also, the calculation seems wrong.. for eg. 6th Jan 2015 and 30th Dec 2018, the years difference should be 3 years right ? why is it showing 27 ?

      What am i missing here ?