Date Difference

[manojkulkarni]

Hi

Difference of these dates 2015-03-31 & 2014-12-01, i am getting 121 days Qlikview. But same thing in excel & sql is giving 120 days.

Actually it should have been 120 days. What could be the reason for this ?

[sinanozdemir]

Hi Manoj,

By using Interval() function, I am getting 120 days:

[robert_mika]

Double check your calculation.

[sinanozdemir]

Honestly, I didn't know you could just do what you did in order to get the day difference between two days.

Thanks

[robert_mika]

You are welcome.

To close this thread you can mark answers as Helpful or answered.