Hi All,

I have been using a calculation I found on technet for quite a while that calculates the years, months and days between two given dates.

It had been working great until today. I had the dates 02/01/2015 amd 12/02/2015 in my date_start and date_end fields respectively. This calculation returned 9 months and 30 days. This is not accurate! It should have read 10 months and 2 days. How do I fix it? Here is the calc I used in the link below.

http://help.filemaker.com/app/answers/detail/a_id/870/kw/calculating%20elapsed%20days

Thank you all.

Stephen

I wouldn't say I'm making any assumptions. All I want is the exact calculation. I was wrong earlier. When I entered 02/01/2015 to 11/30/2015, it gave me 9 months and 1 day. Which is absolutely wrong. I don't see how "wrong" is arbitrary. It should have been 9 months and 29 days. I was incorrect when I wrote 30 days. But, it all doesn't matter anyway because I found one that works.

http://www.briandunning.com/cf/57