You need to sign in to do that
Don't have an account?
cl0s3r
Advanced Workflow Formula
I want to compare two date fields to a third and if they are >= update another field. The formula I am attempting to use is below, IK have no syntax issues but for some reason it doesnt update the field. I am out of ideas, has anyone else had this type of issue?
IF(AND(AvStatusChange__c != NULL,OR( BAA_Modification_Date__c >= AvStatusChange__c , OAA_Modification_Date__c >= AvStatusChange__c) ), true, false)
What is your WFR criteria and when is it set to evaluate?
also, how about something like this?
The WFR criteria is, "When a record is created, or when a record is edited and did not previously meet the rule criteria". I just tried the code provided but the field still doesnt get updated.
Try changing it to "Every time the record is created or edited"
Can you post a screenshot of your WFR and the record that you're editing with the fields your WFR refers to?