You created a validation rule on the Opportunity object to ensure that the Close Date cannot be in the past.
The formula is: CloseDate < TODAY()
A sales manager complains that they cannot update the Stage of an Opportunity that has already closed in the past — even when they are not changing the Close Date field.
Why is this happening, and how would you fix it while keeping the intended rule intact?
Provide your answer below. ⚠️Please No AI answer. I will require you to explain if I pick you