7 Replies Latest reply on Mar 9, 2016 10:11 AM by Tableau kumar

    Converting the results of a DATEDIFF (day) into Years, Months and Days

    Jeff Held

      I'm attempting to convert a value that is derived from the DATEDIFF function into Years, Months and Days.  I'm using the following to derive the number of days:

       

      DATEDIFF('day',[Date Acquired],Today())

       

      Does anyone know how to covert that number into Years, Months and Days?