+ Start a Discussion
cl0s3rcl0s3r 

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))

 

cl0s3rcl0s3r

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?