AgeOnDate ( Birthdate, AgeDate )

Calculates someone's age based on their given birthdate and the specified date to use as their "Age On Date"

Be the first to rate this function Log in to vote

Kyle Williams - Show more from this author
Augusto Digital
https://www.youtube.com/channel/UCpJlB7cmVNMjbjgY96MEsng

Sample input:

AgeOnDate( "3/29/1979", "5/2/2025" )

Sample output:

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

/*	Author:		Kyle Williams
	Date:		5/2/2025
	Purpose:		Used to calculate someone's current age on a specific Date
*/

Let([
	 ad = GetAsDate( AgeDate )
	;bd = GetAsDate( BirthDate )
	;ageStartYear = Year(ad) - Year(bd) - 1
	;bdThisYear = Date(Month(bd); Day(bd); Year(ad))
	;isValidBD = not ( IsEmpty(bd) or bd > ad )
	;hasHadBD = ad ≥ bdThisYear
	;age = ageStartYear + hasHadBD
];
	If( isValidBD; age; "" )
)

Calculates someone's age based on their given birthdate and the specified date to use as their "Age On Date"

Comments

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

AgeOnDate ( Birthdate, AgeDate )

Comments

Support this website.

Support this website.