topic Re: How to subtract two dates in QlikView https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163195#M915259 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Fri, 27 May 2016 16:04:39 GMT 2016-05-27T16:04:39Z How to subtract two dates https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163193#M915257 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have two dates fields opendate and closedate .</P><P></P><P>i need subtract open date and close date.how to do it.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163193#M915257 2020-11-25T16:16:04Z Re: How to subtract two dates https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163194#M915258 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P><STRONG>Interval(closedate - opendate) as Diff</STRONG></P><P></P><P>or using NetWorkDays()</P><P><STRONG>NetWorkDays(opendate, closedate) as WorkDayDiff</STRONG></P></BODY></HTML> Fri, 27 May 2016 16:01:14 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163194#M915258 sunny_talwar 2016-05-27T16:01:14Z Re: How to subtract two dates https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163195#M915259 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Fri, 27 May 2016 16:04:39 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163195#M915259 2016-05-27T16:04:39Z Re: How to subtract two dates https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163196#M915260 <HTML><HEAD></HEAD><BODY><P>can also use the inherent number value of the date within Qlick</P><P></P><P> = Num(Date1) - Num(Date2)</P></BODY></HTML> Fri, 27 May 2016 16:08:43 GMT https://community.qlik.com/t5/QlikView/How-to-subtract-two-dates/m-p/1163196#M915260 2016-05-27T16:08:43Z