Hi,
I’m trying to create a workflow that updates the ‘payment due’ date to be 7 days after the ‘Invoice Issued’ date when the ‘Invoice Issue Date’ is changed.
I’ve set up a workflow with a condition that has Payment Due Date>equal to> any change.
The workflow is being triggered but the ‘payment due date’ is being set 7 days after the ‘original’ issue date - not the new issue date that triggered the workflow action.
The workflow ‘action’ must be using the issue date before’ the field was changed, rather than the value that caused the ‘any change’ to trigger, because if i change the value again, the due date is updated again; but always adding 7 days to the previous issue date value.
How can I set the workflow to use the new date?
thank you