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

Date Time

Accepted answers

Cremo

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

@Nandakishore

missed adding workflow

1148.yxmd

All comments

Raj

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

aatalai

@Nandakishore take a look a this workflow it should help

First monday of the month.yxmd

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

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

@Nandakishore

missed adding workflow

1148.yxmd

Raj

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703