How to convert the month week into date format?

Tue, 14 May 2013 05:56:31 GMT

Hi all,

I have a date column like this which is belongs to a financial year (Say 2012-2013).

MonthWeek

Apr Week 1

Apr Week 2

Apr Week 3

Apr Week 4

Apr Week 5

May Week 1

May Week 2

May Week 3

May Week 4

May Week 5

Jun Week 1

Jun Week 2

Jun Week 3

Jun Week 4

Jun Week 5

Jul Week 1

Jul Week 2

Jul Week 3

Jul Week 4

Jul Week 5

Aug Week 1

Aug Week 2

Aug Week 3

Aug Week 4

Aug Week 5

Sep Week 1

Sep Week 2

Sep Week 3

Sep Week 4

Sep Week 5

Oct Week 1

Oct Week 2

Oct Week 3

Oct Week 4

Oct Week 5

Nov Week 1

Nov Week 2

Nov Week 3

Nov Week 4

Nov Week 5

Dec Week 1

Dec Week 2

Dec Week 3

Dec Week 4

Dec Week 5

Jan Week 1

Jan Week 2

Jan Week 3

Jan Week 4

Jan Week 5

Feb Week 1

Feb Week 2

Feb Week 3

Feb Week 4

Mar Week 1

Mar Week 2

Mar Week 3

Mar Week 4

Mar Week 5

The data will be updated on sunday of the each week.So i have to find sunday date of each week.

How to find the Sunday date of each week? to convert this column into date format(DD/MM/YYYY)

Please provide your comments and ideas to achieve it.

Thanks in advance.

Regards

Kumar

topic How to convert the month week into date format? in QlikView

How to convert the month week into date format?