Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert to Date from week number and day number

hima_shar
8 - Asteroid

Hi All,

 

I have a problem.

 

Input date has a string field having values something like this - 1733B

It means - Year 2017, 33rd week, and B is Monday ( week starts from Sunday).

 

I have to change this string to a date i.e 2017/08/14 (YYYY/MM/DD)

 

Can anyone pls suggest how to achieve this.

 

Regards

Himanshu

 

 

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @hima_shar,

 

That was a bit of a head scratcher but here we go:

 

StringtoDate.PNG

hima_shar
8 - Asteroid

Excellent LordNeilLord.

 

Thank you very much for this.

 

Labels