4 Replies Latest reply on Sep 20, 2016 8:24 AM by Gregory de Lima

    DATEDIFF Month Returns Range Outside of Expected

    Gregory de Lima

      I used this evaluation to return a rolling 12 months from the last full month:

       

      If  DATEDIFF('month',max([Commission Date]),total(max([Commission Date]))) >= 1

          AND

          DATEDIFF('month',max([Commission Date]),total(max([Commission Date]))) <= 12

      THEN TRUE

      ELSE FALSE

      END

      This would evaluate to 09/2015...08/2016 = TRUE

       

      And I have one line item that's returning a month outside of this range (in Jan 2014) as a result, all the rest of the rows are showing up with an odd date range.

       

       

      What could cause this and how can I avoid it without outright excluding?