topic dates difference in QlikView https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415853#M427730 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I need to calculate the number of days of a case&nbsp; = date_modif - date_creation without counting saturday and sundays, only working days</P><P></P><P>the two field date has this format : 8/28/2017 8:37:40 AM</P><P></P><P>Any idea ?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Sep 2017 13:34:43 GMT master_student 2017-09-26T13:34:43Z dates difference https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415853#M427730 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I need to calculate the number of days of a case&nbsp; = date_modif - date_creation without counting saturday and sundays, only working days</P><P></P><P>the two field date has this format : 8/28/2017 8:37:40 AM</P><P></P><P>Any idea ?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 26 Sep 2017 13:34:43 GMT https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415853#M427730 master_student 2017-09-26T13:34:43Z Re: dates difference https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415854#M427731 <HTML><HEAD></HEAD><BODY><P>Use NetWorkDays() function</P><P></P><P><STRONG>NetWorkDays(</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>date_creation, </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>date_modif)</STRONG></SPAN></SPAN></P></BODY></HTML> Tue, 26 Sep 2017 13:37:04 GMT https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415854#M427731 sunny_talwar 2017-09-26T13:37:04Z Re: dates difference https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415855#M427732 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>If(Not WildMatch(WeekDay(date_modif) and WeekDay(date_creation), 'Sat', 'Sun'), date_modif - date_creation)</STRONG></P><P><STRONG>OR</STRONG></P><P><STRONG><STRONG style="font-size: 13.3333px;">If(Not WildMatch(WeekDay(date_modif) and WeekDay(date_creation), 'Sat', 'Sun'), Interval(Date(Date#(date_modif,'M/DD/YYYY hh:mm:ss TT'),'DD-MM-YYYY') - <STRONG style="font-size: 13.3333px;">Date(Date#(<STRONG style="font-size: 13.3333px;">date_creation</STRONG>,'M/DD/YYYY hh:mm:ss TT'),'DD-MM-YYYY'), 'DD')</STRONG>)</STRONG></STRONG></P></BODY></HTML> Tue, 26 Sep 2017 13:46:21 GMT https://community.qlik.com/t5/QlikView/dates-difference/m-p/1415855#M427732 Anil_Babu_Samineni 2017-09-26T13:46:21Z