Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Week Number to Date Formula?

Highlighted
5 - Atom

Hi, I have a set of data that has week numbers instead of dates, and I'm trying to add a column with a date to go onto do time series forecasting. I imagine it's possible to input start date and keep adding 7 days, but I will eventually be using files with different starting week numbers so if it's possible to avoid doing this for every file that would be best! I know there are ways to go from a date to a week number, but I haven't used Alteryx enough to know if there's a way of doing it the other way around? Thanks!

Highlighted
Alteryx Certified Partner

Hi @rachel9989 ,

 

Do you have the information about the year ? Or do you have only a column with week numbers as 1,2,3...51,52 ?

 

Cheers,

 

Jean-Baptiste

Highlighted
16 - Nebula

Here's one way. From year and weeknumber, find the Monday of the 1st week of the year, then add the (weeknumber-1) * 7days to that date.

 

Example attached

 

DavidP_0-1589362355855.png

 

Labels