Forum Academy Marketplace Showcase Pricing Features

Calculate age in year, month and days

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

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:
Screen Shot 2021-10-24 at 5.32.39 PM

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

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

Best,

1 Like

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.

image

This topic was automatically closed after 70 days. New replies are no longer allowed.