Calculate Age between Birth Date and a Given Date

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
Jhstephenson
Posts: 297
Joined: Wed Apr 22, 2015 11:44 pm

Calculate Age between Birth Date and a Given Date

Post by Jhstephenson »

The Age function works great if I want to calculate someone's age as of right now.

But, how can it be calculated based on a given date? Say, I have an event and I want to know how old a person was on that event date, not the current date.

I can get close by using Day_DIFFERENCE(DOB,EventDate)/365

But that does not give an exact age because of Leap Years. It is really close, but not quite precise enough for my needs.

Is there some other Function I am missing?
BobK
Posts: 544
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: Calculate Age between Birth Date and a Given Date

Post by BobK »

Jhstephenson wrote: Is there some other Function I am missing?
Yes, check out Function FULL_YEARS
Bob
Post Reply