cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Compute a date in workflow A to schedule workflow B

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.

Labels: (1)
0 Kudos
Reply
1 Reply
Highlighted
Nintex Newbie

Re: Compute a date in workflow A to schedule workflow B

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.

0 Kudos
Reply