9 Replies Latest reply on Oct 9, 2018 11:21 AM by Angie Chubb

    Calculating 12 months prior from a go live date

    Grace Herron

      I am trying to calculate twelve months prior to a go live date. I have tried multiple different formulas and can't get it exactly.

       

      Not every item will have a go live date so I have tried:

       

      if not isnull([Re-Route GO Live Date]) then DATEDIFF('month',[Prior Month to Go live Date],[Prior Month to Go live Date])<=12 and DATEDIFF('month',[Prior Month to Go live Date],[Prior Month to Go live Date])>=1

      END

       

      Any help is much appreciated!