SOLVED
Finding Previous or next Monday based on Condition from a date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
VahidGoli
8 - Asteroid
‎06-08-2021
04:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
apathetichell
19 - Altair
‎06-08-2021
04:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-08-2021
07:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @apathetichell , you are a legend mate. Thanks.
MackStewart
8 - Asteroid
‎10-04-2022
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is awesome. changed -1 to -0 to get Sunday - just realised that -0 is redundant. :D
