Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

AccurateAge ( start ; end )

Calculate Age in Years and Days Accurately

  Average rating: 5.0 (1 vote) Log in to vote

Tom G - Show more from this author

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

Let ( [ startday = DayOfYear ( start ) ; // capture the calendar day number of the start year endday = DayOfYear ( end ) ; // capture the calendar day number of the end year days = endday - startday ; // determine the difference (in days) between start day and end day startyear = Year ( start ) ; // capture the year of the start date endyear = Year ( end ) ; // capture the year of the end date years = endyear - startyear ; // determine the difference (in years) between start year and end year leapday = DayOfYear ( Date ( 12 ; 31 ; endyear ) ) - DayOfYear ( Date ( 12 ; 31 ; startyear ) ) ; // if start xor end years are leap years, result will be +1 or -1. if start and end years are same duration, result is 0 ageyears = If ( endday < startday ; years - 1 ; years ) ; // if day of year of end date is less than start date, age years subtracts 1. otherwise show age years agedays = If ( endday < startday ; DayOfYear ( Date ( 12 ; 31 ; endyear ) ) + days ; days ) - leapday // if end day of year is less than start day of year, days will be negative, subtracted from last day of end year to give days age. If positive, days is days age. leap day added to days age. ] ; If ( not ( Length ( start ) and Length ( end ) ) ; "" ; // return blank if either parameter is empty Case ( not ageyears ; "" ; ageyears = 1 ; ageyears & " year" ; ageyears & " years " ) & Case ( not agedays ; "" ; agedays = 1 ; agedays & " day" ; agedays & " days" ) ) ) Click to copy

AccurateAge accurately calculates the period of time between any two dates and displayed in the form of "x years y days".
It also handles leap years in the start or end dates.
Can be used to determine age, shelf life, duration, time to expiration, etc. Basically any period between two dates.

 

Comments

		KHALID SAID , K.D Nov 23, 2019
I want a function that calculates the number of days between two dates (only the number of days)

		Tom G Nov 24, 2019
Just do: GetasDate ( [EndDate] ) - GetasDate ( [StartDate] ) FileMaker automatically calculates the difference in number of days.

		TA May 20, 2020
Thanks Can you make it in Years, Months, Days ?

		Tom G May 21, 2020
Sorry, no, not at this time.

		Alireza Jul 1, 2020
hi and thank you how can i edit this function to split it into two calculations for the same record for alive people like above and for dead people it counts only the years and days that they lived thanks again

		Tom G Jul 1, 2020
You can do that by manipulating the parameter values. For example (DateofBirth and DateofDeath are both date fields in the person's record): Let ( [ start = DateofBirth ; end = If ( DateofDeath ; DateofDeath ; Get ( CurrentDate ) ) ] ; AccurateAge ( start ; end ) )

		Tom G Aug 16, 2021
TA, Accurate Age YMD now available. Calculates age in years-months-days...

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: