I have a Process Builder (We change to Flow soon- but want to have all the automation to the record at one place so that it is easy to move to Flow).
Use Case: When the Expected Revenue Date is moved out of this Month i need to get a Chatter post in the Group (this part is done through a Flow) . I used the below formula criteria in the Decision.
ExpectedRevenueDate__C = IF( NOT(ISBLANK(ExpectedRevenueDate1, ExpectedRevenueDate1, ExpectedrevenueDate2)
ExpectedRevenueDate1 -- > Changes through Automation ( Value of Scheduled Installation Date)
Problem: When i change the ExpectedRevenueDate1 --> PB passes the decision (true) and the chatter msg is posting.
But when i change Scheduled Installation Date -->which Changes ExpectedRevenueDate1 --> which changes the ExpectedRevenueDate__C. This is the General way of record update happens
In this case the Decision is not Passing even though the Criteria is fulfilling.
I checked debug logs and it showed the decision as False.
Process Builder Decision Formula:
AND( ISCHANGED([Order].ExpectedRevenueDate__c), NOT(ISNULL([Order].ExpectedRevenueDate__c ) ), MONTH(PRIORVALUE([Order].ExpectedRevenueDate__c )) = MONTH(TODAY()) , MONTH([Order].ExpectedRevenueDate__c ) > MONTH(TODAY()) )
Any help would be greatly appreciated.