Can someone help me with this formula i'm trying to build in process builder? Thanks!
AND(
[WorkOrderLineItem].RecordTypeId = 0124Q000001FyQJQA0,
ISBLANK([WorkOrderLineItem].Date_Ordered__c ),
NOW() > [WorkOrderLineItem].Contract_Approved_Date__c +14
)
5 respuestas
Hi Rebecca,
You may try with below formula:
Option1 :
AND(
[WorkOrderLineItem].RecordTypeId = '0124Q000001FyQJQA0',
ISBLANK([WorkOrderLineItem].Date_Ordered__c ),
NOW() > ([WorkOrderLineItem].Contract_Approved_Date__c +14)
)
Option2: (if Approved Date is data type as Date):
AND(
[WorkOrderLineItem].RecordTypeId = '0124Q000001FyQJQA0',
ISBLANK([WorkOrderLineItem].Date_Ordered__c),
TODAY() > ([WorkOrderLineItem].Contract_Approved_Date__c +14)
)
