14 Replies Latest reply on Nov 3, 2014 12:58 PM by alquimby

    Inaccurate Elapsed Time Calc - Help!

    Stephen41

      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