topic Re: Days between 2 Dates in QlikView https://community.qlik.com/t5/QlikView/Days-between/m-p/1548311#M744818 <P>Check this:</P> Sat, 23 Feb 2019 08:29:42 GMT Claudiu_Anghelescu 2019-02-23T08:29:42Z Days between https://community.qlik.com/t5/QlikView/Days-between/m-p/1548302#M744815 Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Days-between/m-p/1548302#M744815 soha1902 2020-11-25T16:16:04Z Re: Days between 2 Dates https://community.qlik.com/t5/QlikView/Days-between/m-p/1548304#M744816 <P>=Date2 - Date1</P><P>&nbsp;</P><P>But Date2 should to have the same format as Date1</P><P>So Date#(Date2,'DD/MM/YYYY') as Date2</P> Sat, 23 Feb 2019 08:14:50 GMT https://community.qlik.com/t5/QlikView/Days-between/m-p/1548304#M744816 Claudiu_Anghelescu 2019-02-23T08:14:50Z Re: Days between 2 Dates https://community.qlik.com/t5/QlikView/Days-between/m-p/1548305#M744817 <P>&nbsp;</P><P>&nbsp;</P> Sat, 23 Feb 2019 11:57:19 GMT https://community.qlik.com/t5/QlikView/Days-between/m-p/1548305#M744817 soha1902 2019-02-23T11:57:19Z Re: Days between 2 Dates https://community.qlik.com/t5/QlikView/Days-between/m-p/1548311#M744818 <P>Check this:</P> Sat, 23 Feb 2019 08:29:42 GMT https://community.qlik.com/t5/QlikView/Days-between/m-p/1548311#M744818 Claudiu_Anghelescu 2019-02-23T08:29:42Z Re: Days between 2 Dates https://community.qlik.com/t5/QlikView/Days-between/m-p/1548406#M744819 <P>Use interval() function</P><P>&nbsp;</P><P>Interval(date1-date2,'DD')</P> Sun, 24 Feb 2019 08:13:44 GMT https://community.qlik.com/t5/QlikView/Days-between/m-p/1548406#M744819 pradosh_thakur 2019-02-24T08:13:44Z