Compute a date in workflow A to schedule workflow B

[carlosn]

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.

[carlosn]

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.