make a week number a proper weekending date e.g. 'DD-MM'YYY'

[#1]

hi does anyone know how i can convert a week number (0-52) into a weekending date?

e.g. week number 1 = weekending 10-04-2011

how can i write a formula so that week 1 can be '10-04-2011'

similarly week 2 to appear as 17-04-2011'

any ideas?

[#2]

Hi,

you could use makeweekdate() for that and then weekend().

So i.e.: weekend(MakeWeekDate(2011,1))

Does this solve your question?

Cheers,

Gerald

================================

http://www.globeqlik.com

Join the GlobeQlik- User Group here

[#3]

Hi, I'm guessing you might have weekyear date in the following format YYYYWW (e.g. 201101), then you could use a expression similar to the following:

date(weekend(MakeWeekDate(left(WeekYearField,4),right(WeekYearField,2))),'DD-MM-YYYY')

Regards

[reanfadyl]

Helpful thanks.

[Anonymous]

Thanks for expression.