topic Re: Calculate the age difference between two dates in months in QlikView https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712589#M256571 <HTML><HEAD></HEAD><BODY><P>= round((Today() - makedate(2014,1,1))/30)</P><P>replace makedate with your field</P></BODY></HTML> Tue, 16 Sep 2014 21:16:49 GMT maxgro 2014-09-16T21:16:49Z Calculate the age difference between two dates in months https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712587#M256569 <HTML><HEAD></HEAD><BODY><P>Is there a way to calculate the age difference between two date fields in months which can possible be done in the expression itself</P><P></P><P>Today()-Datefield which will give the result in months?</P></BODY></HTML> Tue, 16 Sep 2014 20:55:24 GMT https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712587#M256569 2014-09-16T20:55:24Z Re: Calculate the age difference between two dates in months https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712588#M256570 <HTML><HEAD></HEAD><BODY><P>The answer is here: </P><P><A href="https://community.qlik.com/thread/47580">How Do I Get the Number of Months Between Two Dates?</A></P></BODY></HTML> Tue, 16 Sep 2014 21:12:24 GMT https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712588#M256570 2014-09-16T21:12:24Z Re: Calculate the age difference between two dates in months https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712589#M256571 <HTML><HEAD></HEAD><BODY><P>= round((Today() - makedate(2014,1,1))/30)</P><P>replace makedate with your field</P></BODY></HTML> Tue, 16 Sep 2014 21:16:49 GMT https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712589#M256571 maxgro 2014-09-16T21:16:49Z Re: Calculate the age difference between two dates in months https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712590#M256572 <HTML><HEAD></HEAD><BODY><P>Thanks <SPAN class="j-post-author" style="font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;"><A href="https://community.qlik.com/people/maxgro">maxgro</A> </STRONG></SPAN></P></BODY></HTML> Tue, 16 Sep 2014 22:24:37 GMT https://community.qlik.com/t5/QlikView/Calculate-the-age-difference-between-two-dates-in-months/m-p/712590#M256572 2014-09-16T22:24:37Z