First monday of the month

[Nandakishore]

Hi ,

Is there a way to calculate or check if today is the first monday of the month . 

Thanks

[Raj]

@Nandakishore yes this can be done with logic
adding workflow for reference.

[aatalai]

@Nandakishore take a look a this workflow it should help

[cjaneczko]

You can use the following in a Formula tool. Replace the [DateTime_Out] with your date field. This will give you the first Monday of any month. You can combine this with an IF statement to see if today is the first Monday of the month.

datetimeadd(datetimeparse(datetimeformat([DateTime_Out],"%Y-%m")+"-01","%Y-%m-%d"),mod(8-tonumber(datetimeformat(datetimeadd([DateTime_Out],-tonumber(datetimeformat([DateTime_Out],"%d"))+1,"days"),"%u")),
7),"days")

[Cremo · Accepted solution]

Hi @Nandakishore,

I would use a formula tool to check whether the specific date is Monday and it is less or equal the 7th day of the month. Please refer to below screenshot

 

[Raj · Accepted solution]

@Nandakishore 

missed adding workflow

[Raj]

@Nandakishore 
i think i complicated it 
other solutions are easier to use