Alteryx Designer Desktop Discussions

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

Get next Monday date

Belletmns
8 - Asteroid

Hi Team,

 

Need you help, I want to get the next Monday date even if I run the report any dates this week.

 

Here is m data:

Belletmns_1-1628663890142.png

What I want to do:

Belletmns_2-1628663910799.png

 

Report will run any time of this week and next Monday date should be consistent.

 

Thank you

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @Belletmns 

 

Here is how you can do it. I am assuming date is in proper date format.

 

Edit: I have updated to adjust for sundays too.


Workflow:

atcodedog05_1-1628664664874.png

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @Belletmns 

 

If its not in exact format and you want it in a proper format. You can do something like below.

 

Workflow:

atcodedog05_0-1628665770614.png

 

Hope this helps : )

 

Belletmns
8 - Asteroid

Thank you!! @atcodedog05

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Belletmns 

Cheers and have a nice day!

Labels