topic Re: # Years Between Dates in QlikView https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358398#M826082 <HTML><HEAD></HEAD><BODY><P>AGE(YearEnd(Today()), MY_DATE) perhaps</P></BODY></HTML> Mon, 10 Jul 2017 15:30:25 GMT marcus_malinow 2017-07-10T15:30:25Z # Years Between Dates https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358397#M826081 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to create a field with the number of years <STRONG>between a date and the 31/12</STRONG> from the year I run the script.</P><P></P><P>(In this case would be 31/12/<SPAN style="text-decoration: underline;">2017</SPAN> but next year would be 31/12/<SPAN style="text-decoration: underline;">2018</SPAN>).</P><P></P><P>I previously had <STRONG>AGE(TODAY(), MY_DATE)</STRONG> but I need to modify the function.</P><P></P><P>Do you know how to do that?</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358397#M826081 microwin88x 2020-11-25T16:16:04Z Re: # Years Between Dates https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358398#M826082 <HTML><HEAD></HEAD><BODY><P>AGE(YearEnd(Today()), MY_DATE) perhaps</P></BODY></HTML> Mon, 10 Jul 2017 15:30:25 GMT https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358398#M826082 marcus_malinow 2017-07-10T15:30:25Z Re: # Years Between Dates https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358399#M826083 <HTML><HEAD></HEAD><BODY><P>May be NetWorkDays function you mean to say or YearEnd() function for Today() declaration.</P></BODY></HTML> Mon, 10 Jul 2017 15:32:56 GMT https://community.qlik.com/t5/QlikView/Years-Between-Dates/m-p/1358399#M826083 Anil_Babu_Samineni 2017-07-10T15:32:56Z