Calculate exact age

Hey there, my first post on this forum that brought me many answers in the past few weeks :slight_smile:

I’m looking for a way to calculate an exact age, based on EU format dates. Like:

  • DoB: 04/08/1992 (EU: 4th of August, 1992)
  • D: 11/07/2024 (EU: 11th of July, 2024)

I already applied what has been exposed here: Calculate age in year, month and days, and this is my expression:
image

It works… but not totally. For example, when the anniversary month > current month, then the calculated value is negative:
image

The expected result is: 31 year(s), 11 month(s) and 7 day(s). I guess there would be an issue too if anniversary day > current day.

Is there anything I can do about this ?
Moreover: what is the format of the current date in Bubble and can it be changed ?

Thanks !