Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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