I need to calculate the difference between 2 Dates in Days according to the DayCount Rule 30/360

In Excel it is easy =Days360(StartDate, EndDate,1)
30/360 = every month = 30 days, the year =360
In MS-Access no problem as well, just in Filemaker I can not find a solution


for example:
StartDate of a Loan: 2010-01-01
Accrued Days Date: 2010-05-20
= 139 days

I can not just take the difference and divide by 365 because that would not go along with the 30/360 rule

anybody an idea?
thanks

in filemaker get the number of whole months between the two dates, multiply by 30; get the difference in days between the two dates; if the number of days >=30 add i month, then take the months, x by 30, add the days. off the cuff before coffee - will this work?

H

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.