Calculate Age base on end of month

[peewan]

So I have the report 2019-01-01 to 2019-12-31, Age basket: <1, 1-10, 11-21; and have to calculate doctor visits base on Age - end of each enrollment month.

Age = (2019-01-31, DOB)
Age = (2019-02-28, DOB)
...
How can I do this?

Thank you

[magicianer]

You can use the _last_of_month() function on your enrollment month field and then compare it to the date of birth field using _years_between().