topic Re: Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2 in Archived Groups https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62220#M3786 <HTML><HEAD></HEAD><BODY><P>I assumed it calculates days as well. Just came to know its only for years.</P><P></P><P>Thanks for the response.</P><P></P><P>Regards,</P><P>Anilet Nirmal</P></BODY></HTML> Wed, 07 Feb 2018 07:24:54 GMT anilet123 2018-02-07T07:24:54Z Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2 https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62218#M3784 <HTML><HEAD></HEAD><BODY><P>Age() function is not working as expected both in script and UI in QlikSense Desktop November Patch 2.</P><P></P><P>Date format used is 'M/D/YYYY'.</P><P></P><P>Following is the screenshot of the issue. It returns zero value. </P><P></P><P><IMG alt="568ffd2265864a609f5231f5e85231fa.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/192663_568ffd2265864a609f5231f5e85231fa.png" style="height: 150px; width: 620px;" /> </P><P><SPAN style="font-size: 13.3333px;">Hope it gets fixed soon.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Regards,</P><P>Anilet Nirmal</P></BODY></HTML> Wed, 23 Jul 2025 14:48:52 GMT https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62218#M3784 anilet123 2025-07-23T14:48:52Z Re: Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2 https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62219#M3785 <HTML><HEAD></HEAD><BODY><P>Why you think this is wrong? The result of this calculation is 0 (zero) years..</P></BODY></HTML> Wed, 07 Feb 2018 07:21:58 GMT https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62219#M3785 rbecher 2018-02-07T07:21:58Z Re: Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2 https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62220#M3786 <HTML><HEAD></HEAD><BODY><P>I assumed it calculates days as well. Just came to know its only for years.</P><P></P><P>Thanks for the response.</P><P></P><P>Regards,</P><P>Anilet Nirmal</P></BODY></HTML> Wed, 07 Feb 2018 07:24:54 GMT https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62220#M3786 anilet123 2018-02-07T07:24:54Z Re: Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2 https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62221#M3787 <HTML><HEAD></HEAD><BODY><P>You can easily calc days by:</P><P></P><P>= Collection_Date - Bill_Date</P></BODY></HTML> Wed, 07 Feb 2018 07:26:43 GMT https://community.qlik.com/t5/Archived-Groups/Age-function-not-working-as-expected-both-in-script-and-UI-in/m-p/62221#M3787 rbecher 2018-02-07T07:26:43Z