topic Re: Calculate weekend date from week and year in QlikView

Calculate weekend date from week and year

neha_sri — Mon, 01 Sep 2014 07:27:39 GMT

Hi,

I have week and year with me and I want to find weekend date from that.

I have used this logic

floor(num(date((MakeDate(left(trim([Year Week]),4),1,1)-WEEKDAY(MakeDate(left(trim([Year Week]),4),1,3))+ WEEK *7) + 1) ))

but If I check 01-Jan-2012 but its weekend comes 31-Dec whereas it should come as 01-Jan .

How to correct it

Thanks in anticipation

jagan — Mon, 01 Sep 2014 07:34:57 GMT

Hi Neha,

Try using

LunarWeekend()

LunarWeekStart()

Ex:

LunarWeekStart(YearStart(Today()))

LunarWeekEnd(YearStart(Today()))

Regards,

Jagan.

MarcoWedel — Mon, 01 Sep 2014 08:25:57 GMT

MakeWeekDate(year, week, 6) = Sunday

MakeWeekDate(year, week, 5) = Saturday

hope this helps

regards

Marco