Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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