6 Replies Latest reply on Jan 17, 2014 6:53 AM by philmodjunk

    Date Calculation:  IF ( Date > 3 months, Num1 , Num2)

    SteveH

      Title

      Date Calculation:  IF ( Date > 3 months, Num1 , Num2)

      Post

           Hi Smart People,

           I am trying to create a calculation for benefits.  This benefit for this particular company begins after three months of their initial hire date.  Is there a way I can calculate this based on the hire date?

           Something like:

           IF( HireDate >= 3 months, Num1, Num2)

            

           Thanks for the help!

           Stephen