AnsweredAssumed Answered

Calculating dates

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

Title

Calculating dates

Post

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,

 

k7rks01

Outcomes