how to change week number to monday date

[#1]

Is there any way to change a week number to the Monday date?

For example, I have the week number in my data (i.e 201431, 201430, 201429, etc) and I would like to show it as (7/28/2014, 7/21/2014, 7/14/2014, etc)

How can I do this in the script?

[#2]

Attached with answer.

LOAD *,MakeWeekDate(Left(Field,4),Right(Field,2)) as New INLINE [

    Field

    201431

    201430

    201429

];

Thanks

[#3]

Thank you Ajay.

When 201432 week data is uploaded, will it automatically get updated since it is not in the original inline load?

[jaimeaguilar · Accepted solution]

Hi,

Ajay Prabhakaran pointed out an example with inline data, in your case you just have to include this line in your script (in the table where you want to create this new field):

MakeWeekDate(Left(Field,4),Right(Field,2)) as NewField

regards