6 Replies Latest reply on Nov 15, 2015 2:18 PM by JammieSchmunk

    Calculation question

    JammieSchmunk

      I have gone is circles for 2 days. I just need to know how old an item is...

      I have a purchase date 2 (Which is the date acquired) and under age I have:

      Mod ( Month ( Get ( CurrentDate ) ) - Month ( Purchased Date 2) + 12 - If ( Day ( Get ( CurrentDate ) ) < Day ( Purchased Date 2) ; 1 ; 0 ) ; 12 )

      Yet it's not working. What am I doing wrong?