Working with a PHP calculated data field. It relies on an "anchor" date data field elsewhere in the system, it takes the date and adds 30 days to it (or 15, or minus 45, whatever). All works fine until someone clears the anchor date, then my calculated date field reverts to Jan 1, 1970 and then adds (or subtracts) the days added/subtracted in the calculated field.
The date calculated data field is:
$date = '[[pri_mtgs_and_key_dates_complaint_filed_date]]';
$date = date('M d, Y', strtotime('+15 days', strtotime($date)));
Is there a way to insert some code in the calculated field to say, "if the date field this calculated field uses is cleared, clear the result of the calculated field also?