Constant calculated by a formula

Question

I would like to base a workflow constant on the value of a calculation:

DateTimeAdd(DateTimeNow(), 1, "Months") = the next month based on when the workflow is executed.

I have a number of workflows that are based on the prior or next month and would like to set that as a constant so I don't have to add it to every record or keep calculating it with a formula.

Is there a way to assign a calculated value, like the one above, to a constant in the workflow?

Thanks,

Scott

paulfound · Accepted Answer

Hi @ScottShimer

I haven't yet been able to find a way to dynamically edit a worksheets own constant. But you can update the XML of a workflow from one to another workflows,  so all you do is import the workflow in the input tool, formula tool with find and replace and output tool. This way when the next WF is opened it will have been updated with the new constant.

Hope this is of help, or at least food for thought.