Hi, I need to calculate the accrued interest of a bond in a table (I guess it is the same in a qry). I have a table with all transactions on bonds (purchases and sales). The purchase amount is depending on the quantity and the Price. So far no problem.
But when you buy a bond you need to pay to the seller the accrued interest of the bond. To calculate that I need to know how many days since last coupon payment date. So this is not a complete date (11/30/2012) but only (11/30). Today, being 2/24/2016 it would have to calculate the number of days since the last coupon payment date (11/30/2015) but next year it would have to calculate the days from 11/30/2016. Anyone know how to calculate a number of days since last time the date was 11/30?
Thks in advance
Markus