Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

First monday of the month

Nandakishore
8 - Asteroid

Hi ,

 

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

 

Thanks

6 REPLIES 6
Raj
16 - Nebula

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

aatalai
14 - Magnetar

@Nandakishore take a look a this workflow it should help

cjaneczko
13 - Pulsar

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

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

 

Picture1.png

 

Raj
16 - Nebula

@Nandakishore 

missed adding workflow

Raj
16 - Nebula

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

Labels
Top Solution Authors