# Re: What would be the formula to show the age of a person as of today? I need the result in years

4871 0
cancel
Showing results for
Did you mean:
4 - Data Explorer

DATETIME_DIFF([date1], [date2], ‘units’)

I saw this formula but how do I modify it to include my fields and a result in years for the units?

24 Replies 24
5 - Automation Enthusiast

Maybe there’s something wrong with the data in your Birthday field or there is no information in that field, yet.

Check to make sure the single quotes around `'years'` are straight single quotes (`''`) and not ‘pretty’ matching inverted comma-style single quotes (‘’). Sometimes when you copy-and-paste from the forum, you inadvertently pick up the latter, which will cause an error. Simply overwrite them using the single-quote key on your keyboard.

6 - Interface Innovator

Good thoughts, this fixed it for me!

Here’s my final formula:

DATETIME_DIFF(TODAY(),Birthday, ‘years’)

4 - Data Explorer

Thanks for your response to the “Age” question.

How about instead of Years and Months, you want Years and a Decimal Equivalent for months.

For example exactly 12 years 6 months would simply be 12.5 years old. How to do that .5 calculation within the formula?

Thanks

To build upon @Matt_Bush’s example, try

``````IF(birthday,
DATETIME_DIFF(
TODAY(),
birthday,
'years')&
RIGHT(
ROUND(
MOD(
DATETIME_DIFF(
TODAY(),
birthday,
'days'
),
365
)/365,
1
)&'',
2
)
``````

That gives you `YY.M`.

4 - Data Explorer

I changed birthday to {Birthdate} and used your example, but it failed.
Birthdate is my Field Name

See below:
IF({Birthdate}, DATETIME_DIFF(TODAY(),{Birthdate}, ‘years’) & RIGHT(ROUND(MOD(DATETIME_DIFF(TODAY(),{Birthdate},‘days’), 365)/365, 1) &’’, 2)

Oops, I must’ve dropped a parenthesis between testing the routine and formatting it to post.
Try this:

``````IF(
{Birthdate},
DATETIME_DIFF(
TODAY(),
{Birthdate},
'years'
)&RIGHT(
ROUND(
MOD(
DATETIME_DIFF(
TODAY(),
{Birthdate},
'days'
),
365
)/365,
1
)&'',
2
)
)
``````
4 - Data Explorer

Works PERFECTLY! Thanks Tim!

4 - Data Explorer

I used this formula
=TONOW({DOB}, ‘years’)

4 - Data Explorer

None of the options worked for me! I get the error sign. :frowning:

Screen Shot 2020-01-22 at 11.35.48 AM|429x500