DaysToNextBirthday ( birthdate )

Returns the number of days to the next birthday

Average rating: 4.1 (33 votes) Log in to vote

Theo Ros - Show more from this author

Sample input:

DaysToNextBirthday ( birthdate )

Sample output:

returns 300 when birthdate contains April 12, 1957 and today is June 16 2005.

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

/* ----------------------------------------------------------
Returns the number of days to the next birthday

Return type: Number
Syntax: NextBirthday ( birthdate )

DaysToNextBirthday ( birthdate )  returns 300
when birthdate contains April 12, 1957 and
today is June 16 2005.

Theo Ros
----------------------------------------------------------*/
Let ( now = Get ( CurrentDate ) ;
Case ( Date ( Month ( birthdate ) ; Day ( birthdate ) ; Year( now ) )  <=    now ; 
  Date ( Month ( birthdate ) ; Day ( birthdate ) ; Year ( now ) + 1 ) - now ;
  Date ( Month ( birthdate ) ; Day ( birthdate ) ; Year ( now ) ) - now )
)

Returns the number of days to the next birthday

Return type: Number

Comments

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

DaysToNextBirthday ( birthdate )

Comments

Support this website.

Support this website.