4 Replies Latest reply on Aug 24, 2017 8:47 AM by Joe Oppelt

    Datediff for months doesn't work

    ryan cope

      I'd like to calculate the number of months between two dates.

       

      I have the following formula in tableau:

       

      DATEDIFF('month',#2016-8-1#,#2017-3-1#)

       

      it returns the value of 21, but according to syntax should return 7 (the number of months between august 2016 and march 2017)

       

      am i missing something?

       

      Thanks