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

Kieren MacMillan
kierencom
www.kierencom.ca

Sample input:

YearsAsInt( birthdate ; Get ( CurrentDate ) )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let
(
    [
        d1Float = Year ( date1 ) + Month ( date1 ) / 100 + Day ( date1 ) / 10000;
        d2Float = Year ( date2 ) + Month ( date2 ) / 100 + Day ( date2 ) / 10000
    ];

    Int ( d2Float - d1Float )
)

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.

Comments

		Ian Moree, Nassau Bahamaas Mar 28, 2012
Looking @ this & noticed you accounted for leap year using a different approach but same answer. Great Job! QUick and neat.. KUDOS>>

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

YearsInteger ( date1 ; date2 )

Comments

Support this website.

Support this website.