2 Replies Latest reply on Aug 6, 2012 4:57 PM by fahim m

    caculating Diffrence in years in the past compared to today

    fahim m

      I have list of dates in my spreadsheet on each record - for example 08/22/2006 (DATE). I want to find the diffrence in number of years using TODAY (as of today) using a DATEDIFF calculation.

       

      I used the following calc

      DATEDIFF('year', DATE, TODAY).

      the calculation is giving me wrong and negative answers

       

      I am trying to see the number of years that have elapsed from TODAY compared to 08/22/2006.

       

      I appreciate any help.

       

      Thanks

       

      Fahim.