2 Replies Latest reply on Oct 7, 2015 11:27 AM by ThomasFileMaker

    New to filemaker pro calculation question

    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.