https://community.qlik.com/t5/QlikView/start-date-minus-end-date/m-p/2068116#M1223528 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/222774">@inam</a>&nbsp;If your date is in proper date format you can try below</P> <P>=min(Date)-max(Date)</P> <P>or&nbsp;</P> <P>min(total Date)-max(total Date)</P> Fri, 05 May 2023 10:47:43 GMT Kushal_Chawda 2023-05-05T10:47:43Z https://community.qlik.com/t5/QlikView/start-date-minus-end-date/m-p/2068102#M1223527 <P>Hello Community ,</P> <P>i want start date minus end date. i have table like&nbsp;</P> <TABLE width="147px"> <TBODY> <TR> <TD width="146px">date</TD> </TR> <TR> <TD width="146px">16-Apr-2023</TD> </TR> <TR> <TD width="146px">17-Apr-2023</TD> </TR> <TR> <TD width="146px">18-Apr-2023</TD> </TR> <TR> <TD width="146px">19-Apr-2023</TD> </TR> <TR> <TD width="146px">20-Apr-2023</TD> </TR> <TR> <TD width="146px">21-Apr-2023</TD> </TR> <TR> <TD width="146px">22-Apr-2023</TD> </TR> <TR> <TD width="146px">23-Apr-2023</TD> </TR> <TR> <TD width="146px">24-Apr-2023</TD> </TR> <TR> <TD width="146px">25-Apr-2023</TD> </TR> <TR> <TD width="146px">26-Apr-2023</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>here 16 is startdate &amp; 26 is enddate&nbsp;</P> <P>expected output:</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="64" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 12.75pt;"> <TD width="64" height="17" class="xl65" style="height: 12.75pt; width: 48pt;">finaldate</TD> </TR> <TR style="height: 12.75pt;"> <TD height="17" align="right" style="height: 12.75pt;">-10</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 05 May 2023 10:36:33 GMT https://community.qlik.com/t5/QlikView/start-date-minus-end-date/m-p/2068102#M1223527 inam 2023-05-05T10:36:33Z https://community.qlik.com/t5/QlikView/start-date-minus-end-date/m-p/2068116#M1223528 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/222774">@inam</a>&nbsp;If your date is in proper date format you can try below</P> <P>=min(Date)-max(Date)</P> <P>or&nbsp;</P> <P>min(total Date)-max(total Date)</P> Fri, 05 May 2023 10:47:43 GMT https://community.qlik.com/t5/QlikView/start-date-minus-end-date/m-p/2068116#M1223528 Kushal_Chawda 2023-05-05T10:47:43Z