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?
Calculate Age between Birth Date and a Given Date
-
- Posts: 297
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Calculate Age between Birth Date and a Given Date
Yes, check out Function FULL_YEARSJhstephenson wrote: Is there some other Function I am missing?
Bob