AnsweredAssumed Answered

Calculation field question

Question asked by bate01 on Oct 29, 2010
Latest reply on Sep 2, 2013 by RehmanAkram


Calculation field question


My question is: I have a calc field set up to calculate days delayed from the target due date. I need the calculation to stop calculating if there is a date in the completed field. How do I do this? I have tried some things but they don't work.

My calc so far is set up like this and it works except for it doesn't stop calculating days delayed: 

Days delayed field calc = If(GetAsNumber(Target Date) > 0 and GetAsNumber(Target Date) <= GetAsNumber(Get(CurrentDate));GetAsNumber(Get(CurrentDate))-Target Date; "")

I am using FileMaker Pro 10 on a Mac. The database is located on FileMaker Server.