topic Re: total days in between two dates in QlikView https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330964#M833406 <HTML><HEAD></HEAD><BODY><P>You mean your End date should be something like Today()? </P></BODY></HTML> Wed, 07 Jun 2017 21:15:32 GMT vishsaggi 2017-06-07T21:15:32Z total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330961#M833403 <HTML><HEAD></HEAD><BODY><P>hello</P><P></P><P>how to find total days in between two dates?</P><P></P><P>thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330961#M833403 Anonymous 2020-11-25T16:16:04Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330962#M833404 <HTML><HEAD></HEAD><BODY><P>Since dates are stored as dual both number and date, you can subtract the end date from the start get and use the floor function to get total number of days between two dates.</P><P></P><P>Floor(Num(DateEnd-DateStart))</P></BODY></HTML> Wed, 07 Jun 2017 20:54:34 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330962#M833404 craigsutton 2017-06-07T20:54:34Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330963#M833405 <HTML><HEAD></HEAD><BODY><P>thanks craig..</P><P></P><P>i come to know one thing, i have only one date field and want find total sales between two date ?</P></BODY></HTML> Wed, 07 Jun 2017 21:04:56 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330963#M833405 Anonymous 2017-06-07T21:04:56Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330964#M833406 <HTML><HEAD></HEAD><BODY><P>You mean your End date should be something like Today()? </P></BODY></HTML> Wed, 07 Jun 2017 21:15:32 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330964#M833406 vishsaggi 2017-06-07T21:15:32Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330965#M833407 <HTML><HEAD></HEAD><BODY><P>You can enter your dates in variables (V_Start_date, V_End_date) with two input box.</P><P></P><P>Expression=sum({&lt;[Sales date]={"&gt;=$(=Start_date) &lt;=$(=End_date)"}&gt;}&nbsp; Sales)</P><P></P><P><IMG alt="" class="jive-image image-1" height="183" src="https://community.qlik.com/legacyfs/online/166149_pastedImage_1.png" style="width: 477px; height: 182.935px;" width="477" /></P></BODY></HTML> Wed, 07 Jun 2017 21:34:29 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330965#M833407 sergio0592 2017-06-07T21:34:29Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330966#M833408 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Wed, 07 Jun 2017 21:49:23 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330966#M833408 Anonymous 2017-06-07T21:49:23Z Re: total days in between two dates https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330967#M833409 <HTML><HEAD></HEAD><BODY><P>You want this in Script? Just extending Craig's expression you can try like:</P><P></P><P>Num(Floor(Today() - StartDate)) AS DaysDiff</P></BODY></HTML> Wed, 07 Jun 2017 22:08:20 GMT https://community.qlik.com/t5/QlikView/total-days-in-between-two-dates/m-p/1330967#M833409 vishsaggi 2017-06-07T22:08:20Z