2 Replies Latest reply on Nov 9, 2015 4:01 AM by g4guitar

    How to do a calculation based on an ‘if’ statement?

    g4guitar

      I want to do a calculation based on an ‘if’ statement. I have 2 date fields which are;

       

      1. Joined (date they joined)

      2. Canceled (date they canceled)

       

      If the ‘Canceled date is empty calculate ‘Today’s date minus Joined date'.

      If the Cancel date is populated calculate 'Cancel date minus Joined date’.

       

      How would I set this up?

       

      Thank you very much.