Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
you could use makeweekdate() for that and then weekend().
So i.e.: weekend(MakeWeekDate(2011,1))
Does this solve your question?
Cheers,
Gerald
================================
Join the GlobeQlik- User Group here
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
Helpful thanks.
Thanks for expression.