Brian Dunning's FileMaker Custom Functions

NextBirthday ( dateOfBirth )

Finds the next time a date will occur.

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

Joe   Joe
iSolutions
http://joeeftekhari.com

Share on Facebook Share on Twitter

  Sample input:
NextBirthday("11/05/1991")
  Sample output:
"11/05/2018"

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

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

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.