Difference beetween two dates - 30 days per month

SYLV1G

Hello,

I would like to calculate the number of days beetwen two dates but with a fixed number of days of 30 per month. It is for interest calculation.

Thanks in advance for help

MBerger

Subtracting 2 dates will result in the number of days between them, it's that easy.

vaprog

There's no standard C/AL function for this (MBerger's calculation gives actual days, not 30 days per month), and I don't know of a standard codeunit that provides this either.

So you need to do it yourself. Dissect the dates using DAT2DMY and apply standard corrections and formulae to get interest days.

Some links that might be helpful:
http://en.wikipedia.org/wiki/Day_count_convention (formulae)
http://de.wikipedia.org/wiki/Zinsberechnungsmethode (German description of different calculation types)
http://www.isda.org/c_and_a/trading_practice.html (Excel calculations)

SYLV1G

Thank you four your answer. I will do it by myself

Regards