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?
