3 Replies Latest reply on Jan 3, 2011 11:51 AM by philmodjunk

# Calculate #of days B/W two Dates

### Title

Calculate #of days B/W two Dates

### Post

I am a FM pro11 om windows platform.

I want to calculate payments based on the PMT function but I want to be able to input the first payment due date instead. Therefore the first payment date may be greater or fewer than the interest start date. So I must be able to calculate the number of days from interest start date & the first payment due date then incoporate that into the PMT function. I also am not sure on that either so all the help you can give would be greatly appreciated.

Thanks.

• ###### 1. Re: Calculate #of days B/W two Dates

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

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

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.