Skip to main content
Topics#FormulasKarleen Mendoza's Question
Karleen Mendoza (Wings Insurance) asked in #Formulas
Jun 27, 2018, 2:26 PM

Syntax error in workflow process builder

Hi all! I'm creating a workflow in Process Builder and need to create criteria where the formula evaluates to true.. however I'm getting a syntax error and I have no idea what I am doing wrong!

AND(
DATEVALUE([Policy__c].Scheduler_Date_Time_Renewal__c ) = [Policy__c].Expiration_Date__c - 121,
TEXT([Policy__c].Policy_Stage__c ) = 'In Force', TEXT([Policy__c].Policy_Type__c ) = ‘Work Comp’)
)
||
AND(
DATEVALUE([Policy__c].Scheduler_Date_Time_Renewal__c ) = [Policy__c].Expiration_Date__c - 121,
TEXT([Policy__c].Policy_Stage__c ) = 'In Force', TEXT([Policy__c].Policy_Type__c ) = ‘Property’)

 
4 answers
  1. Rajamohan Vakati (Amazon)
    Jun 27, 2018, 2:57 PM
    OR(
    AND(
    DATEVALUE([Policy__c].Scheduler_Date_Time_Renewal__c ) =[Policy__c].Expiration_Date__c - 121,
    TEXT([Policy__c].Policy_Stage__c ) = 'In Force', TEXT([Policy__c].Policy_Type__c ) = 'Work Comp'
    )
    ,
    AND(
    DATEVALUE([Policy__c].Scheduler_Date_Time_Renewal__c ) = [Policy__c].Expiration_Date__c - 121,
    TEXT([Policy__c].Policy_Stage__c ) = 'In Force', TEXT([Policy__c].Policy_Type__c)  = 'Property'
    )
    )

     
Write an answer...
0/9000