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?
If you have questions or if you want to share your opinion about Aware IM post your message on this forum
2 posts • Page 1 of 1
Yes, check out Function FULL_YEARSJhstephenson wrote: Is there some other Function I am missing?