Discussion Board for collaboration related to QlikView App Development.
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
MakeWeekDate(year, week, 6) = Sunday
MakeWeekDate(year, week, 5) = Saturday
hope this helps