human_hide
Canvas Initiate

Calculate third Monday of a month

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? 

0 Kudos
Reply
3 Replies
graham
Process Pupil

Re: Calculate third Monday of a month

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

0 Kudos
Reply
cblackl2000
Canvas Initiate

Re: Calculate third Monday of a month

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.
0 Kudos
Reply
klintons
Canvas Initiate

Re: Calculate third Monday of a month

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

0 Kudos
Reply