topic Date difference include last date in QlikView https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111181#M367517 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How do I include last or start date while calculating the date difference.</P><P>I get 30 days using CheckOut-CheckIN formula. However, I want to include the start or end date so that I can get 31 NumberOfDays.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CheckIN</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CheckOut</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">NumberOfDays</TH></TR><TR><TD style="padding: 2px;">10/31/2016</TD><TD style="padding: 2px;">11/30/2016</TD><TD style="padding: 2px;">30</TD></TR></TBODY></TABLE><P></P><P>What will be the right formula to do it? Should I just do (CheckOut-CheckIN)+1 ?? Little confused here.</P><P>Thanks.</P></BODY></HTML> Fri, 24 Jun 2016 14:59:43 GMT Anonymous 2016-06-24T14:59:43Z Date difference include last date https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111181#M367517 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>How do I include last or start date while calculating the date difference.</P><P>I get 30 days using CheckOut-CheckIN formula. However, I want to include the start or end date so that I can get 31 NumberOfDays.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CheckIN</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CheckOut</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">NumberOfDays</TH></TR><TR><TD style="padding: 2px;">10/31/2016</TD><TD style="padding: 2px;">11/30/2016</TD><TD style="padding: 2px;">30</TD></TR></TBODY></TABLE><P></P><P>What will be the right formula to do it? Should I just do (CheckOut-CheckIN)+1 ?? Little confused here.</P><P>Thanks.</P></BODY></HTML> Fri, 24 Jun 2016 14:59:43 GMT https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111181#M367517 Anonymous 2016-06-24T14:59:43Z Re: Date difference include last date https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111182#M367518 <HTML><HEAD></HEAD><BODY><P>Just like that</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(CheckOut-CheckIN)+1</SPAN></P></BODY></HTML> Fri, 24 Jun 2016 15:10:26 GMT https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111182#M367518 swuehl 2016-06-24T15:10:26Z Re: Date difference include last date https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111183#M367519 <HTML><HEAD></HEAD><BODY><P>Your formula is correct and also you can use as below:</P><P>=Interval(End_Date - Start_Date,'d')+1 </P></BODY></HTML> Fri, 24 Jun 2016 15:13:16 GMT https://community.qlik.com/t5/QlikView/Date-difference-include-last-date/m-p/1111183#M367519 trdandamudi 2016-06-24T15:13:16Z