How to calculate the number of days between two dates
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.