Alteryx Designer Discussions

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

Finding Previous or next Monday based on Condition from a date

VahidGoli
8 - Asteroid

Hi All,

I have a date, say "2021-06-09", I need a formula or a tool to get the next Monday "2021-06-14", or the previous Monday "2021-06-07", based on the condition.

I know how to do the condition, but I don't know how to achieve the Monday calculation in Alteryx.

 

Would you please guide me on that?

 

Thank you in advance.

2 REPLIES 2
apathetichell
16 - Nebula

Is your date currently set up as a date?  If so - see the attached workflow which uses some nifty date/time tricks.

VahidGoli
8 - Asteroid

Hi @apathetichell , you are a legend mate. Thanks.

Labels