Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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