Brian Dunning's FileMaker Custom Functions

DatesToMonths ( Date1 ; Date2 )

This show the number of months between 2 dates

  Average rating: 4.5 (30 votes) Log in to vote

Timothy Brown   Timothy Brown
Antidote Solutions
http://www.antidotesolutions.com

Share on Facebook Share on Twitter

  Sample input:
1/1/2006
7/1/2006
  Sample output:
7

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

This will calculate the number of months between 2 dates. It will calculate negative months if the Date1 is less than Date2.

 

Comments

Jean-Pierre   Jean-Pierre, Montreal
Jan 5, 2013
I will use this to replace some of my late fees calculations.
Thanks
 
Jonathan Fletcher   Jonathan Fletcher, Fletcher Data Consulting
Aug 20, 2016
Wouldn't 7/1/2006 - 1/1/2006 be SIX months? Just saying'.
 
Jonathan Fletcher   Jonathan Fletcher, Fletcher Data Consulting
Aug 20, 2016
Unless it was intended to count all included months. Should be more clear about what this is for.
 

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.