Display Age as Years,Months

[Leigh]

I would like to calculate age as years and months and display the result in a field in tabular report. I can already display just the age in years, or just the age in months in fields, but I don't want to see 438 months as a persons age as an example.  I want to display both together as years,months. How can I do this?

Thanks

[Ariel]

Hi Leigh, you can try to use this query in your calculated field:

SELECT CAST(DATEDIFF(YEAR,'[@field:DOB]',GETDATE()) AS VARCHAR(10)) + '.' + CAST(DATEDIFF(MONTH,'[@field:DOB]',GETDATE())-(DATEDIFF(YEAR,'[@field:DOB]',GETDATE())*12) AS VARCHAR(10)) AS Age

I reference [@field:DOB] as my birthdays are saved in that field. You would need to replace every instance of [@field:DOB] with your field name parameter using picker tool.

I found this query on http://stackoverflow.com/questions/30048923/how-to-calculate-age-from-date-of-birth-in-years-months-format

Ariel

[Leigh]

Thank you VERY much. This is exactly what I was looking for!

[Ariel]

You are most welcome!

Ariel

[cheonsa]

Hello!

Sharing this formula with you for more exact results:

SELECT CAST((DATEDIFF(m, [@field:DOB], GETDATE())/12) as varchar) + '.' + 
       CAST((DATEDIFF(m, [@field:DOB], GETDATE())%12) as varchar) as Age

 

[Wikiwi]

For a trigger/task solution you can also do this:

[NiceDuck]

You may want to check this one as well: 

It feels odd though, not sure if its an expected behavior.