Convert to Date from week number and day number

[hima_shar]

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

[LordNeilLord · Accepted solution]

Hey @hima_shar,

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

[hima_shar]

Excellent LordNeilLord.

Thank you very much for this.