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,