I have the following formula: Close_Date__c + 20

And I want update the Hire_By__c field when after 20 days of Close_Date__c, but I get the following error:

Error: Formula result is data type (Boolean), incompatible with expected data type (Date)

What can I do?


1 Answer 1


Validation rules cannot update data. As the name would imply, a validation rule simply validates data.

The result of a formula for a validation rule must always be a boolean, as indicated by the error message you're getting.

Instead, you should use a workflow rule with a field update action, process builder, a flow, or an apex trigger.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .