How calculate user age

[austin3]

First off, I didn’t mean to disparage your response, and apologize if that’s how you interpreted it. My intention was to acknowledge that your response actually does work in edge cases, and to provide an alternative for those who don’t want to rely on external sources which we don’t have control over.

In regards to the code not working, I was able to test it out just now in an internal app, and it seems to work fine on my end. I’d love to share a link to an editor to demonstrate this, but unfortunately backend workflows require a paid plan.

If you let me know what issue you’re having, I’d be happy to help you debug it. Your use case of months should be possible with slight modifications.

I’m also working on a plugin which will have a number of useful datetime-related utilities including get age, so I can update this thread when I’ve finished it.

[NigelG]

I posted that in 2018 and never really expected anyone to use the function. Am amazed it is still working even though webtask had been discontinued.

Suspect the issue is with the format of what is being passed in.

MM/DD/YY as a format as ? Are you sure ?

[NigelG]

I will answer my own question …

“formatted as MM/DD/YY” looks like it wants to be a Custom format (MM/DD/YY) which doesn’t work). My fault for overcomplicating it.

But actually, you want YYYY because people are living to 100 now

So…Just pick the 2nd on the list.

Anyway, months in my case was as simple as the difference between the two dates in days / 31 as it just needs to be approx.

[Cosmic.Steve]

Actually, you (simply) need to do what you do in real life:

• you look at the year of birth and make the difference with the current year
• then you check whether the current day of the year is higher than the birth day of the year, and decide to subtract 1 or not

Here is the formula (i’m using a date / time picker):

Hope it helps someone!

[ri_scc_94]

There’s an easy way:

“Current time:extract date >= BIRTHDAY:extract date:formatted as text”
if yes → Current time:extract year - BIRTHDAY:extract year
if not → Current time:extract year - BIRTHDAY:extract year - 1

if you need as number, convert it as number later

[michael.fielding]

I have found a way which is intuitive and easy to write in native bubble. It handles leap years perfectly as far as I can tell.

1. subtract DOB year from this year
2. if current date in DOB’s year is before DOB, subtract 1, otherwise subtract 0

More details:

Calculate age by birthdays date

There’s no need to divide by anything and so no need to estimate the number of days per year: Subtract the year of the Date of Birth (DOB) (e.g. 2001) from the current year (e.g. 2021). This could be too high if we haven’t got to the birthday this year so… Subtract 1 if the current date with the year overwritten to the year of the DOB is before the DOB (otherwise subtract 0). This works perfectly for me, even with a birthday on 29 February. [image] In the value:formatted as number part, use…

And it works in the back end too.

[rvdenik]

I also had to determine somebody’s age depending on a field called “Date de naissance” (date of birth in french) that I wanted to compare to the current date and then store the result in an another field called “Age”.

Here is how I did it, i works fine, at least fo me

1. On the “Age” field, Appearence - Content format = Integer
2. On the “Age” field, Appearence - Initial content :
   
3. On the “Age” field, Conditional, added those 3 conditions :
   
   
   

And that’s all.

To explain how it works, as there is no predefined method in Bubble to handle this “out of the box”, I implemented the following logic :

[karim_ardalan]

Great solution Michael! Works perfectly. Thank you!

[maia.t]

divide by 365.25 and round

[haydaar_05]

You can use current date extract year - date pickers value extract year, then condition show only visible when current date extract date < date pickers value extract date , then text value would be current date extract year - date pickers value extract year -1

Works for me

[haydaar_05]

[markeaston]

Hi, this is how I calculate a Users age.

You can substitute a field such as userAge instead of the DatePicker. It works the same. Seems to work on Leap Years too.

Hope this helps

[manzyun]

In my humble opinion( It’s what we call a contraction, IMHO.)…

How about converting dates to numbers?

For example, March 31, 2025 can be converted to the number 20250331 , right? This may be confusing since it combines Format as and Convert to number operators.

In the Workflow I have put together, the year is truncated and converted to 0331, and then it determines if the birthday has been reached. Please see the screenshot below:

First sequence Screen Shot. This is calculated default value of age .

Second sequence. This is again calculated by subtracting one from the default value if the birthday has not arrived.

Custom format properties

First sequence set value yyyyof Custom format dialog .

Second sequence set value mmdd of Custom format dialog.

P.S.

I’m relieved that I’m not the only one who is having trouble figuring out how to calculate birthdays in Bubble. It took me a total of 30 hours to come up with this method.

[hbelevensocial]

What do you think about:

• Get birthdate and set year to current year
• Check if it is before or after current date:
  • If it’s before: current date year - birthdate year - 1
  • If it’s after: current date year - birthdate year