This content has been marked as final.
Show 5 replies

1. Re: How to calculate the number of days between two dates
comment_1 Mar 10, 2010 2:24 PM (in response to mau_1)1. Try:
Let (
d = Get (CurrentDate)  Last menstrual period
;
Div ( d ; 7 ) & " weeks with " & Mod ( d ; 7 )
)This calculation must be unstored.
2.
Last menstrual period + 286

2. Re: How to calculate the number of days between two dates
mau_1 Mar 10, 2010 3:30 PM (in response to mau_1)Thanks for the quick reply!!! and for the interest!!! :)
the first formula doesnt work at all, because appears a lot of numbers
The second formula have the same problem because only add 286 to the years. example 2010....2296

3. Re: How to calculate the number of days between two dates
comment_1 Mar 10, 2010 3:46 PM (in response to mau_1)Make sure the calculation result type is Text for the first formula, and Date for the second one.

4. Re: How to calculate the number of days between two dates
comment_1 Mar 10, 2010 3:47 PM (in response to mau_1)And that Last menstrual period is a Date field to begin with.

5. Re: How to calculate the number of days between two dates
mau_1 Mar 10, 2010 3:59 PM (in response to mau_1)Thanks very very much for your help!!!!!!!!!!!!!!!
Your are great.