0

I need to calculate the approximate current age in years of patients at a clinic.
We don't have the birthday of all the patients, but we know how old they were when then first registered and we know the date they registered.
I am doing a calculation which returns some strange numbers (e.g., 390, 1271, etc.), which obviously aren't correct.
My calculation goes:
CURRENT AGE = AGE AT REGISTRATION + (CURRENT DATE - DATE OF REGISTRATION).
How to I correct this to make it right?
Thanks.

FIXED IT. Divided the (CURRENT DATE - DATE OF REGISTRATION) by 365 and eureka!
Thanks.

4
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by Bookman
0

You might want to consider 365.25. Keep in mind that every four years there is an extra day :)

0

I think you could use the Year(date) calculation. Try setting up a new field as a calculation, with the following:
Year (registration date)- Age. That should get you somewhere near a birth year.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.