Week start on Monday

[Ronal_bal]

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.

[IraWatt · Accepted 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

[DataNath]

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'.

[Ronal_bal]

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.

[IraWatt]

Hey @Ronal_bal,

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

[Ronal_bal]

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

[DataNath]

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.

[Ronal_bal]

Apologize, I don't have the final output  in the formula of the solution you provided

[DataNath · Accepted solution]

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

[cngclayton]

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