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