NextBirthday ( dateOfBirth )

Finds the next time a date will occur.

Average rating: 5.0 (2 votes) Log in to vote

Joe - Show more from this author
iSolutions
http://joeeftekhari.com

Sample input:

NextBirthday("11/05/1991")

Sample output:

"11/05/2018"

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

// Created: Joe Eftekhari, joe @isolutions-inc.com - 09/21/18
// Parameters: dateOfBirth
// Purpose: To find the next time a date will occur
// Returns: a date

Let ( //begin let        
        [    /* Variables */

			$currentYear = Year ( GetAsDate ( Get ( CurrentHostTimestamp ) ) ) ;
			$nextYear = Year ( GetAsDate ( Get ( CurrentHostTimestamp ) ) ) + 1 ; 
			$birthdayMonth = Month ( dateOfBirth ) ;
			$birthdayDay = Day ( dateOfBirth ) ;
		 	$currentMonth = Month ( GetAsDate ( Get ( CurrentHostTimestamp ) ) ) ;
			$currentDay = Day ( GetAsDate ( Get ( CurrentHostTimestamp ) ) )

        ] ;     /* Calculation */
            GetAsDate ( $birthdayMonth & "/" & $birthdayDay & "/" & 
			Case ( // begin case
				$birthdayMonth < $currentMonth ; $nextYear ;
				$birthdayMonth ≤ $currentMonth and $birthdayDay < $currentDay ; $nextYear ;
				$birthdayMonth = $currentMonth and $birthdayDay ≥ $currentDay ; $currentYear ;
				$birthdayMonth > $currentMonth ; $currentYear

			) // end case

 		   ) // end getasdate
) //end let

This function can be used for any date. Use it with a hidden condition to display a birthday message on a specific employee's dashboard or in another calculation to return a number of days until a next date.

Comments

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

NextBirthday ( dateOfBirth )

Comments

Support this website.

Support this website.