YearsInteger ( date1 ; date2 )
Returns an integer year count between two dates, such as a person's age.
Average rating: 4.1 (34 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This calculation returns an integer year count between the two supplied dates -- perfect for calculating someone's age. It correctly handles all cases and is unaffected by (and unconcerned with!) leap year and other calendar variations/anomolies. This is accomplished by converting each date to a "floating point number" and then simply taking the integer portion of the difference.
Ian Moree, Nassau Bahamaas
Mar 28, 2012
Looking @ this & noticed you accounted for leap year using a different approach but same answer.
QUick and neat..
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.