built in function(coupon date)

[dollygg]

Hello ,

Is there any built in function I could use in MS Access? I would like to get the DTM (date to maturity) :

for example: first coupon date is 03/01/2011(coupon was paid quaterly)
That means the next coupon date is 06/01/2011


maturity date is 03/01/2012
dtm = maturity date - prior coupon date
= 03/01/2012-06/01/2011

[Bob Fitz]

I think the DateDiff() function is what you need.

[dollygg]

The problem is we know the first coupon date and the maturity date only. The prior coupon date always changing.

[dollygg]

The excel formula =COUPDAYS("1/25/1998","11/15/1999",2,1) could solve this problem. I have a table called "CDS" in MS Access. I am wondering if I could use this formula on an Access table.

[Bob Fitz]

Hi

AFAIK the COUPDAYS() function is not available in access but I still think that DateDiff() is what you need. Can you tell us a bit more of where and how you would use COUPDAYS() if it was valid in Access. We may then be able to make a more detailed suggestion.

[dollygg]

Hello,

We can not use the DateDiff () fucntion because the prior coupon date always changing. Our goal is to calculate the number od days between the last coupon date and the maturity date.