I have a custom account lookup field "account_reference__c" and a date field "reference_date__c", any time the "account_reference__c" changes a workflow updates the "reference_date__c" with TODAY. I want to use the process builder to check, anytime the reference_date__c is changed, start a scheduled field update 6 months ahead. in 6 months time it should set the field "update_reference__c" to true. if however the reference date has changed to a later date i want it to reevaluate and start counting 6 months from the new date and not trigger the update_reference__c to true on the previously set day for the field update. So in short, my question is.
- Would the process builder reevaluate before doing the update six months later?
- Would the old process be canceled?
- Would a new process be queued for the new date?