AnsweredAssumed Answered

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

Question asked by g4guitar on Nov 9, 2015
Latest reply on Nov 9, 2015 by 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.

Outcomes