Calculate age by birthdays date

Need help Database
6

There’s no need to divide by anything and so no need to estimate the number of days per year:

  1. 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…
  2. 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 1 for yes and 0 for no.

I got to this simple solution thanks to the insight of @Cosmic.Steve, thank you.

8 Likes