topic Re: Subtracting dates in QlikView https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384940#M421754 <HTML><HEAD></HEAD><BODY><P>I had to change the format in the back end but that worked!</P></BODY></HTML> Fri, 11 Aug 2017 13:11:23 GMT etrotter 2017-08-11T13:11:23Z Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384936#M421750 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>How would I go about subtracting these two dates? I would like to include weekend days.</P></BODY></HTML> Thu, 10 Aug 2017 20:35:42 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384936#M421750 etrotter 2017-08-10T20:35:42Z Re: Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384937#M421751 <HTML><HEAD></HEAD><BODY><P>So what is happening when you try like </P><P></P><P>= Received_Date - Promised_Date </P></BODY></HTML> Thu, 10 Aug 2017 20:54:17 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384937#M421751 vishsaggi 2017-08-10T20:54:17Z Re: Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384938#M421752 <HTML><HEAD></HEAD><BODY><P>Try with </P><P></P><P><STRONG><EM>=Interval(&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Received_Date - Promised_Date,'D hh:mm' </SPAN>)</EM></STRONG></P><P><SPAN class="Code" data-mc-conditions="Primary.NotToTranslate" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px; color: #0f0f0f;"></SPAN><SPAN style="color: #0f0f0f; font-family: 'Open Sans', Arial, sans-serif; font-size: 14px;"> </SPAN></P><P>Regards</P><P>Anand</P></BODY></HTML> Fri, 11 Aug 2017 06:23:17 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384938#M421752 its_anandrjs 2017-08-11T06:23:17Z Re: Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384939#M421753 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Ceil(Interval(Date#([Field2], '<STRONG>MM/DD/YYYY'</STRONG>) - Date#([Field1], '<STRONG>MM/DD/YYYY'</STRONG>), 'DD' ))</SPAN></P></BODY></HTML> Fri, 11 Aug 2017 06:37:36 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384939#M421753 suryaa30 2017-08-11T06:37:36Z Re: Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384940#M421754 <HTML><HEAD></HEAD><BODY><P>I had to change the format in the back end but that worked!</P></BODY></HTML> Fri, 11 Aug 2017 13:11:23 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384940#M421754 etrotter 2017-08-11T13:11:23Z Re: Subtracting dates https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384941#M421755 <HTML><HEAD></HEAD><BODY><P>Glad. Can you close the thread marking correct/helpful responses accordingly. </P></BODY></HTML> Fri, 11 Aug 2017 14:01:49 GMT https://community.qlik.com/t5/QlikView/Subtracting-dates/m-p/1384941#M421755 vishsaggi 2017-08-11T14:01:49Z