Grouping Dates in a New Column

I am using a formula tool to create a "Week Of" column. I need to use the minimum date found within the set of data as my beginning value. This date will always be a Monday and it needs to run through Sunday. For example, in my reference column, let's call it "block date" my minimum date would be 10/23 and my new column would need to show "10/23-10/29". I have tried every variation of date time format, date time add with 6 days and nothing seems to work. Am i approaching this situation incorrectly? Is there an easier way of creating this grouping category in a new column? Please help!!

Date Time

Accepted answers

DataNath

@jmathew94 feels like there must be a more succinct way but I've adapted my original response after you already had the year in there and weren't always just using Monday dates:

Week Of field.png

Produce a Week Of field.yxmd

All comments

cjaneczko

Can you show a sample of your data set with a few weeks of data and what you are trying to accomplish?

DataNath

@jmathew94 are you looking for something like this? In order to do the date calc we need to add the current year and then parse it into ISO format (the only one Alteryx can work with). From there, we can add 6 days to this [Block Date], format it as we need i.e. turn 2023-10-29 (ISO format) into 10/29 (%m/%d). After that, we just need to place it next to the original [Block Date], separated by a hyphen.

Week Of field.png

Produce a Week Of field.yxmd

jmathew94

Date Grouping.JPG

The second column is what i am trying to accomplish. This data appends week over week therefore I will only need the minimum value of that week as my beginning value and the number after the hyphen would be 6 days after that minimum date

DataNath

@jmathew94 feels like there must be a more succinct way but I've adapted my original response after you already had the year in there and weren't always just using Monday dates:

Week Of field.png

Produce a Week Of field.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335