topic Difference between dates in QlikView https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368759#M137078 <HTML><HEAD></HEAD><BODY><P> How to get difference in days between today's date and some other date. Say difference between 4/26/2012 and 4/18/2012 ?</P></BODY></HTML> Thu, 26 Apr 2012 06:28:54 GMT 2012-04-26T06:28:54Z Difference between dates https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368759#M137078 <HTML><HEAD></HEAD><BODY><P> How to get difference in days between today's date and some other date. Say difference between 4/26/2012 and 4/18/2012 ?</P></BODY></HTML> Thu, 26 Apr 2012 06:28:54 GMT https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368759#M137078 2012-04-26T06:28:54Z Difference between dates https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368760#M137079 <HTML><HEAD></HEAD><BODY><P> HI,</P><P></P><P>&nbsp;&nbsp;&nbsp; You can also use interval() function like shown below.</P><P></P><P>&nbsp;&nbsp;&nbsp; interval(Date1 - Date2,'d')</P><P></P><P>&nbsp;&nbsp;&nbsp; Here you can give parameter as d for days,hh for hours,ss for seconds,&nbsp; depending on the requirement of differece.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Thu, 26 Apr 2012 09:25:15 GMT https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368760#M137079 kaushiknsolanki 2012-04-26T09:25:15Z Difference between dates https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368761#M137080 <HTML><HEAD></HEAD><BODY><P> Thanks Kaushik <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 26 Apr 2012 09:30:46 GMT https://community.qlik.com/t5/QlikView/Difference-between-dates/m-p/368761#M137080 2012-04-26T09:30:46Z