How do I add age of an employee with year and months using ORD report?- SAP successfactors

[elnatan2604]

I'm using SAP SuccessFactors and I want to make an ORD report that will give me the age of an employee with his age in years and months. For example today's date is 01/01/2023 and I have an employee that was born in 01/02/2000 his age will be 22.11

[AnnePetteroe]

Hello Elnatan,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,

Anne

[nlgro02343]

The problem here is the accuracy.
First you'll need a calculated column that provides the age indeed with decimals (you can ensure it won't be shown to the actual viewer)
Then you need a calculated column to round it down, to ensure you get 40 in this case for the years. Hereafter you need another calculated column to take the remainder in decimals and do that * 12 (and round up/down where desired). This is not 100% accurate, but its an option. If you want to go fully accurate, it will be a very long if then else statement to perform checks on how many months have passed.