Skip to main content

Hi Everyone

 

Need some help with a simple workflow validation rule.

 

I am trying to update the date field automatically to current date if price of a commodity is greater than 5000 dollars. 

 

1. I have been trying to use this formula IF(Price__c > 5000, Alert_Date__c  = today(), Alert_Date__c  <> today())

 

2. However, every time I try to validate this the date field doesn't changes.

 

Any help is much appreciated. Thanks in advance.