AnsweredAssumed Answered

Inaccurate Elapsed Time Calc - Help!

Question asked by Stephen41 on Nov 3, 2014
Latest reply on Nov 3, 2014 by alquimby

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

Outcomes