Brian Dunning's FileMaker Custom Functions

Years_Diff ( date1 ; date2 )

Months difference part between two dates.

  Average rating: 4.4 (28 votes) Log in to vote

Ron Smith   Ron Smith

Share on Facebook Share on Twitter

  Sample input:
Years_Diff ( 7/14/1958 , 9/8/2006 )
  Sample output:

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

This function calculates the years part of the the difference between two dates. Ex:

7/14/1958 - 9/8/2006 = 48years 6months 11days



Log in to post comments.


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

Under construction. Email me your wish list for improvements.