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,