AnsweredAssumed Answered

How to calculate the number of days between two dates

Question asked by mau_1 on Mar 10, 2010
Latest reply on Mar 10, 2010 by 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

Outcomes