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.
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
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'.
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.
Thanks for the solution. Much appreciated. If you don't mind the can you provide the same solution using single multi-row formula?
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.
Apologize, I don't have the final output in the formula of the solution you provided
Ah wow, turns out I forgot to save it @Ronal_bal - sorry! Attached.
@DataNath Exactly the solution I've been looking for the past 30 minutes!