Week start on Monday
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm trying to get Monday of every weeks date to be the week in a year.
In the example below,
Record 2 has 2022-06-07-week 23 which is Tuesday. The same continues until the 2022-06-09.
But I need the output has 2022-06-06 week-23 for that Tuesday. Where 2022-06-06 is Monday and beginning of the week.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Ronal_bal,
Here is a simple workflow which achieves that:
Probably could do this in one multi row formula but would be difficult to explain.
Any questions or issues please ask :)
HTH!
Ira
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Ronal_bal, what was wrong with the solution here? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/dates-to-be-represented-as-week-dates/...
Seems to fit the requirement, with the 'Final output' field. You could just rename that to be 'Week in Year'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That solution is good. But I'm now trying to figure out the week start date to fit for other dates in the same week.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the solution. Much appreciated. If you don't mind the can you provide the same solution using single multi-row formula?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure I understand - if you look at the solution, I provided an entire week (2022-06-06 through 2022-06-12) and in the 'Final Output' field, they're all 2022-06-06 i.e. the start of the week.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Apologize, I don't have the final output in the formula of the solution you provided
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah wow, turns out I forgot to save it @Ronal_bal - sorry! Attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DataNath Exactly the solution I've been looking for the past 30 minutes!
