Update status based on end date
Hi everyone, I am trying to create a workflow (or workflows) that will update a status depending on the end date on the record.
eg. Change the status of the campaign to completed when the end date has been reached.
I tried the following on another custom object where we have active and inactive status' but it doesnt seem to work - can someone help me?
Workflow Trigger: When new record saved
Workflow rule condition: [<End_Date>] IS NOT NULL
Actions:
eg. Change the status of the campaign to completed when the end date has been reached.
I tried the following on another custom object where we have active and inactive status' but it doesnt seem to work - can someone help me?
Workflow Trigger: When new record saved
Workflow rule condition: [<End_Date>] IS NOT NULL
Actions:
- Wait: 0 seconds
- Field Update: IIf([<End_Date>]<=Today(), 'Inactive', 'Active')
- Wait: Re-evaluate rules after wait is checked.
Until when: [<End_Date>]
0