topic How to calculate date difference to Todays date in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5047#M792231 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have a date field. "[DatePurchased]</P><P></P><P></P><P>How would i calculate the difference from today's date? for example if the value of my date field <SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN> was 15/01/2018, the new calculation would come up with 7</P><P></P><P></P><P></P><P></P><P></P><P>i.e:</P><P>date((date(<SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN>,'MM/DD/YYY')-date(<SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN>,'MM/DD/YYYY')),'DD')</P><P></P><P>I want the result in days </P><P></P><P></P><P></P><P></P><P>Thank you guys</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT aaronnayan 2020-11-25T16:16:04Z How to calculate date difference to Todays date https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5047#M792231 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have a date field. "[DatePurchased]</P><P></P><P></P><P>How would i calculate the difference from today's date? for example if the value of my date field <SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN> was 15/01/2018, the new calculation would come up with 7</P><P></P><P></P><P></P><P></P><P></P><P>i.e:</P><P>date((date(<SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN>,'MM/DD/YYY')-date(<SPAN style="font-size: 13.3333px;">[DatePurchased]</SPAN>,'MM/DD/YYYY')),'DD')</P><P></P><P>I want the result in days </P><P></P><P></P><P></P><P></P><P>Thank you guys</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5047#M792231 aaronnayan 2020-11-25T16:16:04Z Re: How to calculate date difference to Todays date https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5048#M792233 <HTML><HEAD></HEAD><BODY><P>it should be simply:</P><P></P><DIV>Today()-[DatePurchased]</DIV><DIV> </DIV><DIV>This will return the number of days and the time difference.</DIV><DIV> </DIV><DIV> </DIV><DIV>If you want in whole days only:</DIV><DIV> </DIV><DIV>Floor(Today())-Floor([DatePurchased])</DIV></BODY></HTML> Mon, 22 Jan 2018 18:11:24 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5048#M792233 petter 2018-01-22T18:11:24Z Re: How to calculate date difference to Todays date https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5049#M792235 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Today() - </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>DatePurchased</STRONG></SPAN></P></BODY></HTML> Mon, 22 Jan 2018 18:13:12 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5049#M792235 sunny_talwar 2018-01-22T18:13:12Z Re: How to calculate date difference to Todays date https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5050#M792236 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>Today()- DatePurchased</P></BODY></HTML> Tue, 23 Jan 2018 07:11:57 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-date-difference-to-Todays-date/m-p/5050#M792236 shiveshsingh 2018-01-23T07:11:57Z