https://community.qlik.com/t5/QlikView/Calculate-days-duration-between-startdate-and-enddate/m-p/2016514#M1221926 <P>Hi,</P> <P>I have Startdate and Enddate, from this I want to calculate days duration like below</P> <P>Time gap: <BR />0-14 days<BR />15-28 days<BR />&gt;28 days</P> <TABLE width="290px"> <TBODY> <TR> <TD width="131.453px">startdate</TD> <TD width="157.547px">enddate</TD> </TR> <TR> <TD width="131.453px">25-Oct-2022</TD> <TD width="157.547px">29-Oct-2022</TD> </TR> <TR> <TD width="131.453px">28-Oct-2022</TD> <TD width="157.547px">02-Nov-2022</TD> </TR> <TR> <TD width="131.453px">25-Nov-2022</TD> <TD width="157.547px">30-Dec-2022</TD> </TR> <TR> <TD width="131.453px">30-Nov-2022</TD> <TD width="157.547px">30-Dec-2022</TD> </TR> <TR> <TD width="131.453px">02-Dec-2022</TD> <TD width="157.547px">31-Dec-2022</TD> </TR> </TBODY> </TABLE> Wed, 14 Dec 2022 12:50:11 GMT pala_jagadeesh 2022-12-14T12:50:11Z https://community.qlik.com/t5/QlikView/Calculate-days-duration-between-startdate-and-enddate/m-p/2016514#M1221926 <P>Hi,</P> <P>I have Startdate and Enddate, from this I want to calculate days duration like below</P> <P>Time gap: <BR />0-14 days<BR />15-28 days<BR />&gt;28 days</P> <TABLE width="290px"> <TBODY> <TR> <TD width="131.453px">startdate</TD> <TD width="157.547px">enddate</TD> </TR> <TR> <TD width="131.453px">25-Oct-2022</TD> <TD width="157.547px">29-Oct-2022</TD> </TR> <TR> <TD width="131.453px">28-Oct-2022</TD> <TD width="157.547px">02-Nov-2022</TD> </TR> <TR> <TD width="131.453px">25-Nov-2022</TD> <TD width="157.547px">30-Dec-2022</TD> </TR> <TR> <TD width="131.453px">30-Nov-2022</TD> <TD width="157.547px">30-Dec-2022</TD> </TR> <TR> <TD width="131.453px">02-Dec-2022</TD> <TD width="157.547px">31-Dec-2022</TD> </TR> </TBODY> </TABLE> Wed, 14 Dec 2022 12:50:11 GMT https://community.qlik.com/t5/QlikView/Calculate-days-duration-between-startdate-and-enddate/m-p/2016514#M1221926 pala_jagadeesh 2022-12-14T12:50:11Z https://community.qlik.com/t5/QlikView/Calculate-days-duration-between-startdate-and-enddate/m-p/2016515#M1221927 <P>Looks to fit in an if() statement:</P> <P>If(enddate - startdate&gt;28,'&gt;28 days',if(enddate - startdate)&gt;=15,'15-28 days','0-14 days'))</P> Wed, 14 Dec 2022 12:57:04 GMT https://community.qlik.com/t5/QlikView/Calculate-days-duration-between-startdate-and-enddate/m-p/2016515#M1221927 Or 2022-12-14T12:57:04Z