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.