topic Re: how to Exclude Sat and Sun in Date variable? in QlikView https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335534#M411964 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Something like vTodaydate =if(Today()=Weekstart(Today()),date(Today()-3 ),date(Today()-1 ))??</SPAN></P></BODY></HTML> Tue, 18 Apr 2017 13:49:42 GMT Anonymous 2017-04-18T13:49:42Z how to Exclude Sat and Sun in Date variable? https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335533#M411963 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i created one Date variable&nbsp; like this</P><P></P><P>vTodaydate =date(Today()-1 )&nbsp;&nbsp; this give&nbsp; result <STRONG>17/04/2017 </STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Now </STRONG>i want to Exclude Sat and sunday i run report Monday it shoud show only Friday date</P><P></P><P>please help</P></BODY></HTML> Tue, 18 Apr 2017 13:46:27 GMT https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335533#M411963 2017-04-18T13:46:27Z Re: how to Exclude Sat and Sun in Date variable? https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335534#M411964 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Something like vTodaydate =if(Today()=Weekstart(Today()),date(Today()-3 ),date(Today()-1 ))??</SPAN></P></BODY></HTML> Tue, 18 Apr 2017 13:49:42 GMT https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335534#M411964 Anonymous 2017-04-18T13:49:42Z Re: how to Exclude Sat and Sun in Date variable? https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335535#M411965 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">vTodaydate =<STRONG>FirstWorkDate</STRONG>(Today()-1,<STRONG>1</STRONG> )</SPAN></P></BODY></HTML> Tue, 18 Apr 2017 13:55:52 GMT https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335535#M411965 tresB 2017-04-18T13:55:52Z Re: how to Exclude Sat and Sun in Date variable? https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335536#M411966 <HTML><HEAD></HEAD><BODY><P>if ran report on Sunday its giving Saturday data.</P></BODY></HTML> Tue, 18 Apr 2017 14:06:53 GMT https://community.qlik.com/t5/QlikView/how-to-Exclude-Sat-and-Sun-in-Date-variable/m-p/1335536#M411966 2017-04-18T14:06:53Z