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

Hi,

 

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:

 

addDays($stage_completed_date_c,$build_stage_days_c)

 

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?

Outcomes