How calculate user age

[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.