
1. Re: Calculate #of days B/W two Dates
philmodjunk Jan 3, 2011 10:15 AM (in response to jeffd)To compute the number of days between two date fields, just subtract them. This requires that both dates be entered into different fields of type date.
Date2Field  Date1Field
will compute the number of days from Date 1 to Date 2.

2. Re: Calculate #of days B/W two Dates
jeffd Jan 3, 2011 11:32 AM (in response to jeffd)I did have that calculation correct but I had the result field set as a date instead of a number.
Thanks Phil.
Do you know of a simple way to incoporate this result feild into the PMT function to calculate payments?

3. Re: Calculate #of days B/W two Dates
philmodjunk Jan 3, 2011 11:51 AM (in response to jeffd)The PMT function is documented in FileMaker Help. I don't really follow what you are trying to do here. The function requires a term in months. An interest rate that must be divided by 12 if the interest rate is annual instead of monthly and the principle amount.
I don't see anything there that you can manipulate to compute the values you want here.