AnsweredAssumed Answered

calculation question....

Question asked by bate01 on Sep 22, 2011
Latest reply on Sep 22, 2011 by bate01


calculation question....


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.