topic Re: Date Difference in QlikView https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853942#M299347 <HTML><HEAD></HEAD><BODY><P>Double check your calculation.</P><P><IMG alt="2015-07-11_043716.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92560_2015-07-11_043716.jpg" style="height: 364px; width: 620px;" /></P></BODY></HTML> Sat, 11 Jul 2015 03:38:21 GMT robert_mika 2015-07-11T03:38:21Z Date Difference https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853940#M299345 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Difference of these dates 2015-03-31 &amp; 2014-12-01, i am getting 121 days Qlikview. But same thing in excel &amp; sql is giving 120 days.</P><P></P><P>Actually it should have been 120 days. What could be the reason for this ?</P></BODY></HTML> Sat, 11 Jul 2015 02:37:41 GMT https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853940#M299345 manojkulkarni 2015-07-11T02:37:41Z Re: Date Difference https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853941#M299346 <HTML><HEAD></HEAD><BODY><P>Hi Manoj,</P><P></P><P>By using Interval() function, I am getting 120 days:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92567_Capture.PNG" style="height: 165px; width: 620px;" /></P></BODY></HTML> Sat, 11 Jul 2015 03:36:05 GMT https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853941#M299346 sinanozdemir 2015-07-11T03:36:05Z Re: Date Difference https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853942#M299347 <HTML><HEAD></HEAD><BODY><P>Double check your calculation.</P><P><IMG alt="2015-07-11_043716.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92560_2015-07-11_043716.jpg" style="height: 364px; width: 620px;" /></P></BODY></HTML> Sat, 11 Jul 2015 03:38:21 GMT https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853942#M299347 robert_mika 2015-07-11T03:38:21Z Re: Date Difference https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853943#M299348 <HTML><HEAD></HEAD><BODY><P>Honestly, I didn't know you could just do what you did in order to get the day difference between two days.</P><P></P><P>Thanks</P></BODY></HTML> Sat, 11 Jul 2015 03:46:47 GMT https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853943#M299348 sinanozdemir 2015-07-11T03:46:47Z Re: Date Difference https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853944#M299349 <HTML><HEAD></HEAD><BODY><P>You are welcome.</P><P>To close this thread you can mark answers as Helpful or answered.</P></BODY></HTML> Sat, 11 Jul 2015 03:58:27 GMT https://community.qlik.com/t5/QlikView/Date-Difference/m-p/853944#M299349 robert_mika 2015-07-11T03:58:27Z