Calculate next monday

  • 8 December 2016
  • 2 replies
  • 1 view

Badge +2

Hi,

Question: I want to create a workflow which calculate the next Monday no matter when the workflow is started.
I do have now a scheduled workflow which starts at Thursday, then it's easy to calculate the next Monday (add 4 days to the date when the workflow is started)

But now I would like to build a workflow in case the user wants to start the workflow manually.

E.g. the user starts the workflow this week on Wednesday but the next week on Tuesday...

Anyone ideas how I can solve this?

We are using Nintex Workflow 2013 on premise


2 replies

Userlevel 5
Badge +14

you can use fn-FormatDate() inline function to get name of day from reference date.  based on that you should be able to determine how many day to add up to get next Monday.

the formula might look like this

fn-FormatDate(Current Date,ddd)
Badge +2

Thnx Marian!!

Reply