Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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