cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Week start date from Week number and Year

SOLVED
Highlighted
Asteroid

Hi,

 

I have two columns, week number and Year, I need to find the start date of the week(Monday) for that week. Any ideas or leads will be highly appreciated.

Here is a sample

YEARWEEK
201639
201721
201549
20178

 

Thank you,

Poojitha

Quasar

A little bit of a hack solution:

image.png

I create records for the 8 days prior to the week number multiplied by 7, filter down to just Mondays, and grab the biggest date.  You might have to play with the math a little to make sure the week calculations are landing correctly.

 

Hope it helps!

Alteryx Partner

 

Here is a second method that also works and uses a similar approach. 

 

The workflow in Method 2 can be further simplified. Some of the formula fields are included to confirm the logic.

 

2018-02-12_00005.png