how to calculate Accrued Interest in a table or query

[MacAcc]

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

[CJ_London]

try

CDate("11/30/" & year(Date())+(month(date())<12))

[CJ_London]

sorry - that just calculates the last 11/30

use datediff

datediff("d",CDate("11/30/" & year(Date())+(month(date())<12)),Date())

[MacAcc]

tks a lot, will try.