AgeCalculation ( Date ( 4 ; 12 ; 1980 ) ;

Calculates how old a person or a thing was, is, or will be on a user-defined date, based on the date of birth of the person or thing.

Average rating: 4.3 (27 votes) Log in to vote

Watchara Yarnu

http://www.giggogchang.wordpress.com

Sample input:

AgeCalculation( Date( 4 ; 12 ; 1980 ) ; "" )

Sample output:

31 (when the current date is April 12, 2011 for example)

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

Let( [
    
    today = If( IsEmpty( dateToCompare ) ; Get( CurrentDate ) ; dateToCompare ) ;
    currentYear = Year( today ) ;
    dateOfBirthMonth = Month( dateOfBirth ) ;
    dateOfBirthDay = Day( dateOfBirth ) ;
    dateOfBirthYear = Year( dateOfBirth ) ;
    bDayThisYear = Date( dateOfBirthMonth ; dateOfBirthDay ; currentYear )
] ;
Case(
    IsEmpty( dateOfBirth ) ; "" ;
    today ≥ bDayThisYear ; currentYear - dateOfBirthYear ;
    currentYear - dateOfBirthYear - 1
)
)

This function is published on FileMaker Custom Functions
to check for updates and provide feedback and bug reports
please visit http://www.fmfunctions.com/fid/302

Comments

		Lee Smith Jul 22, 2014
You are missing the parameters shown in the original at http://www.fmfunctions.com/fid/302

		Lee Smith Jul 22, 2014
You are missing the parameters shown in the original at http://www.fmfunctions.com/fid/302

		Lee Smith Jul 22, 2014
You are missing the parameters shown in the original at http://www.fmfunctions.com/fid/302 In fact, Iâ€™m not following why you posted this in the first place.

		Watchara Yarnu, Thailand Jul 22, 2014
yes of course, Mr Lee Smith.because this custom function is first in this place. and I've been told on my description where it's first post. Thank you very much for your comment.

		Thomas Hellwig, Hamburg/Germany Apr 3, 2016
So why don't you rectify it?

		Watchara Yarnu, Thailand Apr 4, 2016
I'm apologize for everyone. but you can follow by the original link http://www.fmfunctions.com/fid/302

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

AgeCalculation ( Date ( 4 ; 12 ; 1980 ) ;

Comments

Support this website.

Support this website.