AnsweredAssumed Answered

Calculating dates

Question asked by k7rks01 on May 7, 2010
Latest reply on May 9, 2010 by k7rks01


Calculating dates


Hi Filemaker Forum,


I am looking for some help calculating the difference in months between 2 dates. I am using Filemaker Pro Adv 10.


I have 3 fields.


1st field is drop down date commencement.

2nd field is drop down date cancellation.

3rd field I want to be able to calculate the difference between field 1 & 2 to round up to a complete month.


i.e.         19/07/2009            09/07/2010                  12


I am not sure if it is possible for Filemaker to calculate the difference as a number when the 2 defining fields are xx/xx/xxxx to begin with.


Any help would be greatly appreciated,