Calculate age in year, month and days

[humbertogoveia]

How I can calculate an age cosidering year, month and days.

I’m using :
Current Date/time - DOB :format as days / 365 :floor to calculate years old, but I can’t find a way to get the months and days.

Which formula should I use to get the months and days of an age?

If someone

[JeffT]

Hello,

Thank you for posting on the forum.

You should be able to achieve your goal by using the extract from date function successively for the year, month and date by subtracting one date from the other.
It would look like this:

Here is a link to a demo where I have tested this.

Please do let us know if you have any further questions.

Best,

[humbertogoveia]

Thank you for your reply Jeff.
I’ve tried it and haven’t work for the months.

I need to consume the DOB from the database, and the current date as Current Date/time option.