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.