topic Re: How to get days from weekend? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473066#M176669 <HTML><HEAD></HEAD><BODY><P>try this one</P><P>date(WeekEnd(TempDate),'WWWWW') as CalendarWeekEnd</P><P>or </P><P>date(WeekEnd(TempDate),'WWW') as CalendarWeekEnd</P></BODY></HTML> Fri, 14 Jun 2013 07:56:09 GMT er_mohit 2013-06-14T07:56:09Z How to get days from weekend? https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473064#M176667 <HTML><HEAD></HEAD><BODY><P>Hi..</P><P></P><P>How to get days from weekend?</P><P>I used expression as</P><P>=Day(WeekEnd(CalendarDate))</P><P>But it's not working</P></BODY></HTML> Fri, 14 Jun 2013 07:09:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473064#M176667 2013-06-14T07:09:25Z Re: How to get days from weekend? https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473065#M176668 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>WeekDay() function like this</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>WeekDay(WeekEnd(CalendarDate)) as day2,</STRONG></P><P></P><P>or</P><P></P><P><STRONG>date(WeekEnd(CalendarDate),'www') as day1,</STRONG></P></BODY></HTML> Fri, 14 Jun 2013 07:49:38 GMT https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473065#M176668 2013-06-14T07:49:38Z Re: How to get days from weekend? https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473066#M176669 <HTML><HEAD></HEAD><BODY><P>try this one</P><P>date(WeekEnd(TempDate),'WWWWW') as CalendarWeekEnd</P><P>or </P><P>date(WeekEnd(TempDate),'WWW') as CalendarWeekEnd</P></BODY></HTML> Fri, 14 Jun 2013 07:56:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-days-from-weekend/m-p/473066#M176669 er_mohit 2013-06-14T07:56:09Z