Brian Dunning's FileMaker Custom Functions

ApproxDateRange ( date1 ; date2 )

Evaluates two dates and returns a text string that describes the difference between them to an approximately half-month precision. It doesn't matter which date is more recent.

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

Fritz Mills   Fritz Mills
Media LightBridge, LLC
http://www.medialightbridge.com/

Share on Facebook Share on Twitter

  Sample input:
"12/6/1954" ; "4/18/1952"
  Sample output:
2 years, 8-1/2 months.

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

This function evaluates two dates and returns a text string that describes the difference between them to an approximately half-month precision. It is designed to be used when a "conversational" date range description is most appropriate, such as when describing the difference in age between two persons of similar age, or the age of a very young child. It doesn't matter which date parameter is the more recent 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.