AnsweredAssumed Answered

New to filemaker pro calculation question

Question asked by ThomasFileMaker on Oct 7, 2015
Latest reply on Oct 7, 2015 by ThomasFileMaker

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.

Outcomes