Skip to main content

Hello,

 

I want to calculate the third Monday of the month an item is created in a list and mark the item as non compliant if it is created after the third Monday. I have tried to calculate the "3rd Monday of the current month" using a calculated column, but to no joy.

 

Can someone shed more light on how this can be done? 

I would do this by evaluating the first day of the month

current date - todays day number +1

(eg 2019-03-20 - 20 -> 2019-02-28

+1 -> 2019-03-01)

using this article

https://community.nintex.com/t5/Community-Blogs/Day-of-the-Week-Number/ba-p/77155

determine what day of the week it is

if its not a Monday, add the right number of days to bring it to the first Monday

now add 14 days to give you the 3rd Monday

Hi Graham, can you please provide the details on which action(s) you're using for this? I'm able to get some parts working but not the final result and think perhaps I'm not using the correct action.

v date= DateTime variable of Todays Date


I get a parsing error when trying to get todays day number using Day(vdate) in a convert action


I tried making the variable to store the value in a number and tried it as an integer I get parsing error either way. What have I done wrong?


 


My monthly site work flow will need to do actions on 3rd Monday, 4th Thursday , 4th Saturday and 4th Sunday of the month

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings