topic Expression Date in Water Cooler https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529140#M1978 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Could somebody tell me which expression I have to use te make the difference between 2</P><P>dates in workdays ?</P><P></P><P>Thanks in advance.</P><P></P><P>Marc</P></BODY></HTML> Fri, 17 Jan 2014 16:00:56 GMT 2014-01-17T16:00:56Z Expression Date https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529140#M1978 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>Could somebody tell me which expression I have to use te make the difference between 2</P><P>dates in workdays ?</P><P></P><P>Thanks in advance.</P><P></P><P>Marc</P></BODY></HTML> Fri, 17 Jan 2014 16:00:56 GMT https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529140#M1978 2014-01-17T16:00:56Z Re: Expression Date https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529141#M1979 <HTML><HEAD></HEAD><BODY><P>Use the networkdays function</P><P></P><P class="syntax"><A name="kanchor523"></A><A name="networkdays"></A><SPAN class="Bold"><EM>networkdays (</EM></SPAN><EM><SPAN class="Italic">start:date, end_date {, holiday}</SPAN><SPAN class="Bold">)</SPAN> </EM></P><P>Returns the number of working days (Monday-Friday) between and including <SPAN class="Italic">start_date</SPAN> and <SPAN class="Italic">end_date</SPAN> taking into account any optionally listed <SPAN class="Italic">holidays</SPAN>. All parameters should be valid dates or timestamps. </P><P></P><P class="example"><STRONG>Examples:</STRONG></P><P><SPAN class="Code">networkdays ('2007-02-19', '2007-03-01')</SPAN> returns 9&nbsp; </P><P><SPAN class="Code">networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26')</SPAN> returns 8&nbsp; </P><P class="syntax"><A name="kanchor524"></A><A name="firstworkdate"></A><SPAN class="Bold">firstworkdate(</SPAN><SPAN class="Italic">end_date, no_of_workdays {, holiday</SPAN>} <SPAN class="Bold">)</SPAN></P></BODY></HTML> Fri, 17 Jan 2014 16:03:00 GMT https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529141#M1979 Gysbert_Wassenaar 2014-01-17T16:03:00Z Re: Expression Date https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529142#M1980 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thank you for the information.</P><P></P><P>Marc</P></BODY></HTML> Fri, 17 Jan 2014 16:47:21 GMT https://community.qlik.com/t5/Water-Cooler/Expression-Date/m-p/529142#M1980 2014-01-17T16:47:21Z