Age() function not working as expected both in script and UI in QlikSense Desktop November Patch 2

[anilet123]

Age() function is not working as expected both in script and UI in QlikSense Desktop November Patch 2.

Date format used is 'M/D/YYYY'.

Following is the screenshot of the issue. It returns zero value.

Hope it gets fixed soon.

Regards,

Anilet Nirmal

[rbecher · Accepted solution]

Why you think this is wrong? The result of this calculation is 0 (zero) years..

[anilet123]

I assumed it calculates days as well. Just came to know its only for years.

Thanks for the response.

Regards,

Anilet Nirmal

[rbecher]

You can easily calc days by:

= Collection_Date - Bill_Date