5 Replies Latest reply on Mar 10, 2010 3:59 PM by mau_1

    How to calculate the number of days between two dates

    mau_1

      Title

      How to calculate the number of days between two dates

      Post

      Im having troubles with this formula.

      Im gynecologist and I am new with filemaker. I am using filemaker 10 on Mac OSX.

      I have a field with a date called  Last menstrual period and another one called Week of Pregnancy

      So how can I calculate the number of weeks and days between this dates? ( a normal length of a pregnancy  41weeks with 6 days ) 

       

      for example. Last menstrual period 11/10/2009 (dd/mm/yyyy) , Weeks of pregnancy 21weeks with 3 days (calculate with the current day 10/03/2010)

       

      And how can I get a date (field called Estimated date of delivery) from another date (Last menstrual period) adding 286 days . example 11/10/2009 (last menstrual period),  18/07/2010.

      Thanks