age function in year and month format

[Anonymous]

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

[MK_QSL · Accepted solution]

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...