I am new to Filemaker and not quite sure how to do formulas.
Here is what I am trying to do.
If COMPLETE DATE is NOT empty then
ACTIVE = BLANK
PENDING = BLANK
I want to clear the active and pending fields if there is anything in them if a date is showing.
Active and Pending are number fields.
Complete date is a date field.
Thanks for any help.