function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

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)

Steve :-/Steve :-/

What is your WFR criteria and when is it set to evaluate?

Steve :-/Steve :-/

also, how about something like this?

IF(AND(NOT(ISBLANK(AvStatusChange__c)), BAA_Modification_Date__c >=  AvStatusChange__c ), TRUE,
IF(AND(NOT(ISBLANK(AvStatusChange__c)), OAA_Modification_Date__c >=  AvStatusChange__c ), TRUE, FALSE))



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.

Steve :-/Steve :-/

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?