2 Replies Latest reply: May 15, 2014 10:12 AM by a2z143 _ RSS

    Calculated Field

    a2z143 _

      Need your help again.

       

      I have 2 fields "Status" and "Vested Date". I need a formula that will look at Status field and pick up any "T" (Terminated) and then look at the Vested Date field for any date greater than today and push that date 100 years (New Vested Date).

       

      Sample:

       

      Status            Vested Date        New Vested Date

      T                   11012011              11012011

      A                   01012008              01012008

      A                   01012008              01012008

      T                   01012012              01012112

       

      Thanks