5 Replies Latest reply on Jun 6, 2014 12:57 PM by Prashant Sharma

    Date difference for DOB

    praveen p

      Hi All,

       

      I am trying to calculate age and facing some issues

       

      DATEDIFF( ‘year’, [Date of Birth], TODAY())

       

      However when I see the results they are getting rounded

       

      Example: when the users age is 28years1month its showing as 28 years same when we have difference in days

       

      so I am trying to get exact age with years month and days

       

      May be something like this in Excel I believe which I found online

       

      =DATEDIF (E1, TODAY( ),"Y") & " Years, " & DATEDIF (E1, TODAY( ),"YM") &

      " Months, " & DATEDIF (E1, TODAY( ),"MD") & " Days"

       

      Can some please help ASAP

       

      Thanks,

      Praveen