2 Replies Latest reply on Jan 25, 2017 8:12 AM by Lior Gil

    Exact Date difference Calculation

    Lior Gil

      Hi All,

       

      I'd like calculate the difference between start date and end date

      and created calculated filed:

      ATTR(datediff('year', [Start date],[End date]))

      for example:

      start date - 1.9.2006

      end date - 31.12.2016

      the result : 10.00

       

       

      the result is not accurate, as I need the exact difference which is - 10 years and 4 month

       

       

      can Tableau calculate it?

       

       

      Thanks in advanced,

      Lior