Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie2
Contributor II
Contributor II

Age

Hello,

Using the below as an expression, what else is needed to show this as year and month i.e 1 year 3 month please

=Today()-[Effective Start Date]

Thank you in advance

 

 

1 Reply
rdelagarde
Contributor III
Contributor III

Hi,

Calculating the difference in years is very easy thanks to the Age() function:

Age(Toaday(), [Effective Start Date])

But getting the number of months is more complicated. You can find the answer here: age function in year and month format