topic Re: How to calculate the delay (number of days) between tow differents dates ? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423399#M429072 <HTML><HEAD></HEAD><BODY><P>May be this,</P><P></P><P><STRONG>Ceil(Interval(Date#(DateField2, 'MM/DD/YYYY hh:mm:ss') - Date#(DateField1, 'MM/DD/YYYY hh:mm:ss'), 'DD' ))</STRONG></P><P></P><P>or</P><P></P><P>simply This,</P><P></P><P><STRONG>Ceil(Interval (Date2-Date1,'DD'))</STRONG></P><P></P><P>*Above ,You can mod according to your date format.</P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Fri, 01 Sep 2017 13:07:41 GMT HirisH_V7 2017-09-01T13:07:41Z How to calculate the delay (number of days) between tow differents dates ? https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423396#M429069 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>How to calculate the delay (number of days) between two differents dates ?</P><P></P><P></P><P>Thanx a lot<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P>Regards</P><P>Ali</P></BODY></HTML> Fri, 01 Sep 2017 12:01:21 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423396#M429069 bouderbc 2017-09-01T12:01:21Z Re: How to calculate the delay (number of days) between tow differents dates ? https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423397#M429070 <HTML><HEAD></HEAD><BODY><P>May be just this</P><P></P><P><STRONG>Date2 - Date1</STRONG></P></BODY></HTML> Fri, 01 Sep 2017 12:02:15 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423397#M429070 sunny_talwar 2017-09-01T12:02:15Z Re: How to calculate the delay (number of days) between tow differents dates ? https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423398#M429071 <HTML><HEAD></HEAD><BODY><P>Hi Ali,</P><P></P><P>If you want simply the number of days you can substract the first Date from the second.</P><P></P><P>But if you want the number of working days, you can use NetworkDays() function in the same way.</P></BODY></HTML> Fri, 01 Sep 2017 12:31:57 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423398#M429071 YoussefBelloum 2017-09-01T12:31:57Z Re: How to calculate the delay (number of days) between tow differents dates ? https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423399#M429072 <HTML><HEAD></HEAD><BODY><P>May be this,</P><P></P><P><STRONG>Ceil(Interval(Date#(DateField2, 'MM/DD/YYYY hh:mm:ss') - Date#(DateField1, 'MM/DD/YYYY hh:mm:ss'), 'DD' ))</STRONG></P><P></P><P>or</P><P></P><P>simply This,</P><P></P><P><STRONG>Ceil(Interval (Date2-Date1,'DD'))</STRONG></P><P></P><P>*Above ,You can mod according to your date format.</P><P></P><P>HTH,</P><P>Hirish</P></BODY></HTML> Fri, 01 Sep 2017 13:07:41 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-the-delay-number-of-days-between-tow-differents/m-p/1423399#M429072 HirisH_V7 2017-09-01T13:07:41Z