age function in year and month format

Anonymous — Fri, 17 Jul 2015 15:32:10 GMT

if i have birthdate, how can i write age funcation in such a manner it will show me number of years.month .. for example if age is 28 years 3 months. then it has to show me as 28.3

Re: age function in year and month format

MK_QSL — Fri, 17 Jul 2015 15:42:31 GMT

age(Today(),DOB) & ' Years and ' &(if(day(Today()) >= day(DOB),

mod((Year(Today())*12+Month(Today()))-(Year(DOB)*12+Month(DOB)),12),

if(mod((Year(Today())*12+Month(Today()))-(Year(DOB)*12+Month(DOB)),12)=0,11,mod((Year(Today())*12+Month(Today()))-(Year(DOB)*12+Month(DOB)),12)-1))) &' Months'

CHANGE DOB to Whatever your date field...

topic Re: age function in year and month format in QlikView

age function in year and month format

Re: age function in year and month format