topic Re: Hello, aggregate function between reported date and present date. in QlikView https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374385#M813132 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A>‌ , then just subtract the two dates to get the difference in days.</P></BODY></HTML> Fri, 29 Sep 2017 21:44:42 GMT swuehl 2017-09-29T21:44:42Z Hello, aggregate function between reported date and present date. https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374384#M813131 <HTML><HEAD></HEAD><BODY><P>Hello, i am just starting to Qlikview, and i am planning to make a report which count how old is the ticket already been by using two columns ( reported date and Present date). </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374384#M813131 edmund_m_r_sant 2020-11-25T16:16:04Z Re: Hello, aggregate function between reported date and present date. https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374385#M813132 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A>‌ , then just subtract the two dates to get the difference in days.</P></BODY></HTML> Fri, 29 Sep 2017 21:44:42 GMT https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374385#M813132 swuehl 2017-09-29T21:44:42Z Re: Hello, aggregate function between reported date and present date. https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374386#M813133 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can age() or interval().</P><P>check these</P><P><A href="https://community.qlik.com/thread/90807">Calculate Age in Qlikview</A></P><P><A href="http://qlikviewmaven.blogspot.com/2010/11/time-interval-between-two-timestamps.html" title="http://qlikviewmaven.blogspot.com/2010/11/time-interval-between-two-timestamps.html">QlikView Maven: Time interval between two timestamps</A></P><P><A href="https://community.qlikview.com/thread/191642" title="https://community.qlikview.com/thread/191642">DateDiff | Qlik Community</A></P><P></P><P>Rgds,</P><P>Tharindu</P></BODY></HTML> Sat, 30 Sep 2017 09:02:46 GMT https://community.qlik.com/t5/QlikView/Hello-aggregate-function-between-reported-date-and-present-date/m-p/1374386#M813133 dinuwanbr 2017-09-30T09:02:46Z