topic time conversion in QlikView https://community.qlik.com/t5/QlikView/time-conversion/m-p/787231#M278481 <HTML><HEAD></HEAD><BODY><P>In my table i have casecreated and case closed fields.i want the output as no.of working days between that case created and caseclosed</P></BODY></HTML> Thu, 20 Nov 2014 10:45:12 GMT 2014-11-20T10:45:12Z time conversion https://community.qlik.com/t5/QlikView/time-conversion/m-p/787231#M278481 <HTML><HEAD></HEAD><BODY><P>In my table i have casecreated and case closed fields.i want the output as no.of working days between that case created and caseclosed</P></BODY></HTML> Thu, 20 Nov 2014 10:45:12 GMT https://community.qlik.com/t5/QlikView/time-conversion/m-p/787231#M278481 2014-11-20T10:45:12Z Re: time conversion https://community.qlik.com/t5/QlikView/time-conversion/m-p/787232#M278482 <HTML><HEAD></HEAD><BODY><P>Networkdays(CaseCreatedDt,CaseClosedDt)</P></BODY></HTML> Thu, 20 Nov 2014 10:46:07 GMT https://community.qlik.com/t5/QlikView/time-conversion/m-p/787232#M278482 anbu1984 2014-11-20T10:46:07Z Re: time conversion https://community.qlik.com/t5/QlikView/time-conversion/m-p/787233#M278483 <HTML><HEAD></HEAD><BODY><P>NetworkDays(Date(case created),Date(case closed),'Possible holiday dates')) as [Working Days]</P></BODY></HTML> Thu, 20 Nov 2014 10:46:37 GMT https://community.qlik.com/t5/QlikView/time-conversion/m-p/787233#M278483 simondachstr 2014-11-20T10:46:37Z