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
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
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