topic Re: Networkdays() Function?? in QlikView https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929776#M321544 <HTML><HEAD></HEAD><BODY><P>I have tried using this but it only accepts one date..</P></BODY></HTML> Wed, 18 Nov 2015 10:13:41 GMT rohitians 2015-11-18T10:13:41Z Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929772#M321540 <HTML><HEAD></HEAD><BODY><P>Dear Users,</P><P></P><P>I am using the following code</P><P></P><P>NetWorkDays(Sales_Mis_SALES_LOGIN_DATE,Sales_Mis_SANCTION_DATE,$(vHoliday)) as SANCTION_DAYS</P><P></P><P>I wanna pass mutiple days in vHoliday but i am not getting desired result,</P><P></P><P>vHoliday='11/11/2015','12/11/2015'</P><P></P><P>Request you to help.</P><P>Or Just suitable option to achieve thi I have set of 10 dates which should be avoided for calculation of sanction days.</P><P>Thanks and Regards,</P><P></P><P>Rohit</P></BODY></HTML> Wed, 18 Nov 2015 09:31:22 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929772#M321540 rohitians 2015-11-18T09:31:22Z Re: Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929773#M321541 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>vHoliday= Chr(39) &amp; MakeDate(2015, 11, 11) &amp; Chr 39, </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Chr(39) &amp; MakeDate(2015, 12, 11) &amp; Chr 39</STRONG></SPAN></SPAN></P></BODY></HTML> Wed, 18 Nov 2015 09:42:12 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929773#M321541 sunny_talwar 2015-11-18T09:42:12Z Re: Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929774#M321542 <HTML><HEAD></HEAD><BODY><P>Good Explanation in the Below Document.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-5314">Find Net Working Days</A></P></BODY></HTML> Wed, 18 Nov 2015 09:47:20 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929774#M321542 settu_periasamy 2015-11-18T09:47:20Z Re: Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929775#M321543 <HTML><HEAD></HEAD><BODY><P>try to provide Numbers instead of actual date in variable. for example 42326</P></BODY></HTML> Wed, 18 Nov 2015 10:09:21 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929775#M321543 Kushal_Chawda 2015-11-18T10:09:21Z Re: Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929776#M321544 <HTML><HEAD></HEAD><BODY><P>I have tried using this but it only accepts one date..</P></BODY></HTML> Wed, 18 Nov 2015 10:13:41 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929776#M321544 rohitians 2015-11-18T10:13:41Z Re: Networkdays() Function?? https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929777#M321545 <HTML><HEAD></HEAD><BODY><P>Are the dates in fields of similar formats? If so, try</P><UL><LI>&nbsp;&nbsp;&nbsp;&nbsp; remove '=' while defining variable</LI><LI>&nbsp;&nbsp;&nbsp;&nbsp; remove '$' from variable in networkdays()</LI></UL></BODY></HTML> Wed, 18 Nov 2015 10:25:08 GMT https://community.qlik.com/t5/QlikView/Networkdays-Function/m-p/929777#M321545 tresB 2015-11-18T10:25:08Z