4 Replies Latest reply on Sep 22, 2011 1:34 PM by bate01

    calculation question....

    bate01

      Title

      calculation question....

      Post

      I need a calculation for the field Date complete minus field Life Cycle date in to give me field Days in Life cycle. The problem with this format (Date complete-Life Cycle date in = Days in Life Cycle) is if the date complete field is empty then the field Days in Life Cycle shows a value of -734253 or something like that. How do I eliminate this problem?

       

      I am using FileMaker Pro 11 and I am a novice.

      Thank you for your help.