Brian Dunning's FileMaker Custom Functions

GetAge ( birthdate )

Calculates the number of years, months, & days based on your birthdate

  Average rating: 3.9 (48 votes) Log in to vote

Danny Leung   Danny Leung
Bloomington Public Schools
https://www.bloomington.k12.mn.us

Share on Facebook Share on Twitter

  Sample input:
GetAge( Date(9; 2; 1972) )
  Sample output:
36 years, 9 months, & 30 days

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

This is a much easier way to calculate the age with years, months, & days based on the birthdate you provided.

 

Comments

Needs Work   Needs Work, Washington D.C.
Jul 6, 2009
Today = 7, 6, 2009

GetAge ( date( 7;5;2008) ) = 1 years, 12 months, & 1 days

One year and 12 months? Huh?? Needs some work!
 
Chris Stasny   Chris Stasny, Oxford, MS
Oct 5, 2009
This is what I use for my Age function

Age (DOB )

Let (
[
NumberOfDays = Get ( CurrentDate ) - GetAsDate ( DOB )
]
;
Int ( NumberOfDays / 365.24 )
)
 
Matt   Matt, Vermont
Nov 12, 2009
Does anyone check to see how many other functions already exist for exactly the same purpose?
 
Henry Perret - Gentil   Henry Perret - Gentil, Bogotá, Colombia
Aug 26, 2010
If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )
 
Henry Perret - Gentil   Henry Perret - Gentil, Bogota Colombia
Aug 26, 2010
If ( Month ( Get ( CurrentDate )) < Month (DATEOFBIRTH) ; Year ( Get ( CurrentDate ) ) - Year (DATEOFBIRTH ) - 1 ; Year ( Get ( CurrentDate ) ) - Year (Fecha Nacimiento ) )
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.