In workflow A I would like to setup a a schedule for workflow B to run on the first day of the quarter.
This thread gives me a perfectly adequate way to compute the first day of the next quarter. However, I don't know where to implement the formula in the workflow. The "Calculate Date" and "Math Operation" blocks are both extremely simplistic.
How can I carry out a complex date computation that I can then use for scheduling a workflow?
I'm on SP 2013 with Nintex 2013.
I found a potential solution.
You can utilize a Query Excel Services block. I created a "WorkflowHelper.xlsx" in my Shared Documents. I put the fancy math into the Excel spreadsheet, and then just query the spreadsheet. The query block allows you to update cell values before retrieving the results.
I don't need to run this very often, so I don't see it becoming a resource issue. However, I don't know what the impact of this method would be if the workflow were to run often.