topic Re: Get today - 2 working days in QlikView https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452781#M168967 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can also try NetWorkDays(). To quote from the manual ....</P><P>"networkdays (start:date, end_date {, holiday})</P><P>Returns the number of working days (Monday- Friday) between and including start_date and end_</P><P>date taking into account any optionally listed holidays. All parameters should be valid dates or times-tamps.</P><P></P><P>Examples:</P><P>networkdays ('2007-02-19', '2007-03-01') returns 9&nbsp; </P><P>networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8"</P></BODY></HTML> Fri, 28 Sep 2012 12:26:56 GMT Anonymous 2012-09-28T12:26:56Z Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452779#M168965 <HTML><HEAD></HEAD><BODY><P>I need to make at the time of loading a date variable is set to Day - 2 working days, anyone know how to subtract 2 days excluding Saturday and Sunday</P><P>in script? Thank you.</P></BODY></HTML> Fri, 28 Sep 2012 11:59:58 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452779#M168965 2012-09-28T11:59:58Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452780#M168966 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style=": ; font-size: 1;"></SPAN></SPAN></P><P><STRONG>=</STRONG></P><STRONG><SPAN style="color: #5a005a; font-size: 8pt;">firstworkdate</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #5a005a; font-size: 8pt;">today</SPAN><SPAN style="font-size: 8pt;">(),</SPAN><SPAN style="color: #4d0000; font-size: 8pt;">3</SPAN></STRONG><STRONG style="font-size: 8pt;">) </STRONG><P></P></BODY></HTML> Fri, 28 Sep 2012 12:25:31 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452780#M168966 2012-09-28T12:25:31Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452781#M168967 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can also try NetWorkDays(). To quote from the manual ....</P><P>"networkdays (start:date, end_date {, holiday})</P><P>Returns the number of working days (Monday- Friday) between and including start_date and end_</P><P>date taking into account any optionally listed holidays. All parameters should be valid dates or times-tamps.</P><P></P><P>Examples:</P><P>networkdays ('2007-02-19', '2007-03-01') returns 9&nbsp; </P><P>networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8"</P></BODY></HTML> Fri, 28 Sep 2012 12:26:56 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452781#M168967 Anonymous 2012-09-28T12:26:56Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452782#M168968 <HTML><HEAD></HEAD><BODY><P>but how do I put this date in a variable in the script, Set and Let not work ...</P></BODY></HTML> Fri, 28 Sep 2012 12:35:39 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452782#M168968 2012-09-28T12:35:39Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452783#M168969 <HTML><HEAD></HEAD><BODY><P>LET varTwoDaysBack = FirstWorkDate(Today(),3);</P><P></P><P>don't forget to end the statement with a semicolon</P></BODY></HTML> Fri, 28 Sep 2012 12:48:56 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452783#M168969 Gysbert_Wassenaar 2012-09-28T12:48:56Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452784#M168970 <HTML><HEAD></HEAD><BODY><P>I need to put single quotes before and after the filter to date, I do this in the script + or &amp;?</P></BODY></HTML> Fri, 28 Sep 2012 12:49:05 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452784#M168970 2012-09-28T12:49:05Z Re: Get today - 2 working days https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452785#M168971 <HTML><HEAD></HEAD><BODY><P>I solve this, </P><P></P><P>chr(39) &amp; FirstWorkDate(Today(),3) &amp; chr(39);</P><P></P><P></P><P>thanks.</P></BODY></HTML> Fri, 28 Sep 2012 12:54:09 GMT https://community.qlik.com/t5/QlikView/Get-today-2-working-days/m-p/452785#M168971 2012-09-28T12:54:09Z