Calculate Age of DoB for specific year

[PamG]

I would like to know how to handle DoB of individuals for a particular year e.g. in the image below are DOBs for Users in the 2020 and how old there were in that year.

However, some of the DoB is recorded as 1Jan1901 so they're 120yrs old or even 0 or 1 yrs old!

I need to be able to compose a workflow/formula to exclude all those Users who are under the age of e.g 16yrs old and over 99yrs older.

I hope you can help us out, and very big thanks in advance

[DataNath]

Hey @PamG you should just be able to use a Filter tool with the following expression:

[2020:Age of User] > 15
AND
[2020:Age of User] < 100

[gautiergodard]

Hey @PamG 

Here is one way you could do this:

Hope this helps!