https://community.qlik.com/t5/App-Development/current-work-day/m-p/1580528#M42401 use networkdays function. e.g. below<BR />NetWorkDays(Date#('2019/04/01','YYYY/MM/DD'),Date#('2019/04/12','YYYY/MM/DD')) returns 10<BR /><BR />so maybe in your case<BR />NetWorkDays(MonthStart(YOURDATEFIELD),YOURDATEFIELD) Wed, 15 May 2019 15:04:35 GMT dplr-rn 2019-05-15T15:04:35Z https://community.qlik.com/t5/App-Development/current-work-day/m-p/1580488#M42393 <P>I am trying to measure if a report is submitted by a certain work day . I am not sure how to do this .</P><P>example:</P><P>mydatefield = <STRONG>2019/04/12.</STRONG> I want to measure if the report was submitted before the 10th work day .</P><P>I am able to figure out <STRONG>network days: 23&nbsp;</STRONG> and <STRONG>day number : 12</STRONG> . However , what needs to be calculated is the day number in relation to the networkdays ie :&nbsp; the 12th of April is actually the <STRONG>10th working day</STRONG> of the month and it is this that I need to calculate.</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:49:56 GMT https://community.qlik.com/t5/App-Development/current-work-day/m-p/1580488#M42393 BlakeT 2024-11-16T05:49:56Z https://community.qlik.com/t5/App-Development/current-work-day/m-p/1580528#M42401 use networkdays function. e.g. below<BR />NetWorkDays(Date#('2019/04/01','YYYY/MM/DD'),Date#('2019/04/12','YYYY/MM/DD')) returns 10<BR /><BR />so maybe in your case<BR />NetWorkDays(MonthStart(YOURDATEFIELD),YOURDATEFIELD) Wed, 15 May 2019 15:04:35 GMT https://community.qlik.com/t5/App-Development/current-work-day/m-p/1580528#M42401 dplr-rn 2019-05-15T15:04:35Z