https://community.qlik.com/t5/App-Development/Years-between-to-dates/m-p/1593184#M43615 <P>I need to calculate how many year between two date the formula I use to get the one date is</P><P>DATE#(date(AGGR(MAX(MAX_PLAN_YEAR+5478),PART_NUMBER),'YYYY')) this will give 2033 because the max date is 2019</P><P>DATE#(date(AGGR(MAX(MAX_PLAN_YEAR),PART_NUMBER),'YYYY')) this will give me 2019</P><P>what is the best way to get how many years difference between the dates ?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 18 Jun 2019 15:49:35 GMT Eaun 2019-06-18T15:49:35Z https://community.qlik.com/t5/App-Development/Years-between-to-dates/m-p/1593184#M43615 <P>I need to calculate how many year between two date the formula I use to get the one date is</P><P>DATE#(date(AGGR(MAX(MAX_PLAN_YEAR+5478),PART_NUMBER),'YYYY')) this will give 2033 because the max date is 2019</P><P>DATE#(date(AGGR(MAX(MAX_PLAN_YEAR),PART_NUMBER),'YYYY')) this will give me 2019</P><P>what is the best way to get how many years difference between the dates ?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 18 Jun 2019 15:49:35 GMT https://community.qlik.com/t5/App-Development/Years-between-to-dates/m-p/1593184#M43615 Eaun 2019-06-18T15:49:35Z https://community.qlik.com/t5/App-Development/Years-between-to-dates/m-p/1593396#M43635 <P>Try this?</P><P><STRONG>Year(Date1)-Year(Date2)</STRONG></P> Wed, 19 Jun 2019 07:35:13 GMT https://community.qlik.com/t5/App-Development/Years-between-to-dates/m-p/1593396#M43635 Anil_Babu_Samineni 2019-06-19T07:35:13Z