AnsweredAssumed Answered

Calculated Field to return 0 when date not entered

Question asked by Cheryl Alderson on Jun 18, 2020
Latest reply on Jun 18, 2020 by Patrick McQueen



I have created a calculated field to forecast the expected date to reach the next stage of construction, using the completion date of the previous stage + agreed days.  Below works as expected:




Except when the ($stage_completed_date_c) hasn't been entered yet, the result returns as 30/11/-0001


How can I get the result to show empty or 0?