Hi All, I need to do two things with a list of dates: set the week to begin on Wednesday then report a week number in full year plus week number format, similar to "%Y%U" in DateTimeFormat that aligns with the shifted week start. I also need the week number to be +1 since Alteryx starts week numbers on 0 and I need them to start on 1. In the example below, the left is what Alteryx would do with the dates if I used formulas to get the day of the week and the week number in "%Y%U" format, and the right side is what I actually need. Any thoughts on how to get the right side? DateDay of WeekYear and week number DateDay of WeekYear and week number12/27/20200202052 12/30/2020020205312/28/20201202052 12/31/2020120205312/29/20202202052 1/1/2021220205312/30/20203202052 1/2/2021320205312/31/20204202052 1/3/202142020531/1/20215202052 1/4/202152020531/2/20216202052 1/5/202162020531/3/20210202100 1/6/202102021011/4/20211202100 1/7/202112021011/5/20212202100 1/8/202122021011/6/20213202100 1/9/202132021011/7/20214202100 1/10/202142021011/8/20215202100 1/11/202152021011/9/20216202100 1/12/20216202101

Shift Day of Week Start and Week Number

Hi All,

I need to do two things with a list of dates: set the week to begin on Wednesday then report a week number in full year plus week number format, similar to "%Y%U" in DateTimeFormat that aligns with the shifted week start. I also need the week number to be +1 since Alteryx starts week numbers on 0 and I need them to start on 1.

In the example below, the left is what Alteryx would do with the dates if I used formulas to get the day of the week and the week number in "%Y%U" format, and the right side is what I actually need. Any thoughts on how to get the right side?

Date	Day of Week	Year and week number	Date	Day of Week	Year and week number
12/27/2020	0	202052	12/30/2020	0	202053
12/28/2020	1	202052	12/31/2020	1	202053
12/29/2020	2	202052	1/1/2021	2	202053
12/30/2020	3	202052	1/2/2021	3	202053
12/31/2020	4	202052	1/3/2021	4	202053
1/1/2021	5	202052	1/4/2021	5	202053
1/2/2021	6	202052	1/5/2021	6	202053
1/3/2021	0	202100	1/6/2021	0	202101
1/4/2021	1	202100	1/7/2021	1	202101
1/5/2021	2	202100	1/8/2021	2	202101
1/6/2021	3	202100	1/9/2021	3	202101
1/7/2021	4	202100	1/10/2021	4	202101
1/8/2021	5	202100	1/11/2021	5	202101
1/9/2021	6	202100	1/12/2021	6	202101

Date Time

Accepted answers

markcurry

Hi @jamesonian

See the attached workflow, it's not the most elegant solution but gives you what you want. It creates the Year and Week values for a date range, and then you can add that to your workflow. Hope that helps.