Week start on Monday

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.

Screenshot 2022-06-22 111150.png

Datasets

Date Time

Accepted answers

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

Ah wow, turns out I forgot to save it @Ronal_bal - sorry! Attached.

Week numbers.yxmd

All comments

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/m-p/954844#M235102

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.

Hey @Ronal_bal,

If you have the time series tools you can do something like this:

Thanks for the solution. Much appreciated. If you don't mind the can you provide the same solution using single multi-row formula?

Ah wow, turns out I forgot to save it @Ronal_bal - sorry! Attached.

Week numbers.yxmd

@DataNath Exactly the solution I've been looking for the past 30 minutes!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703