|
Posted by datagal on 03/09/06 01:02
Doug:
Thanks for the reply. There's nothing wrong with the data (at least
not up to this point in the process) and I'm not calculating interest,
just the prorated Annual Amount by year.
The Annual Amount is the base, is never adjusted up for a leap year and
could make the full years easy if it makes sense to use it.
MonthlyAmt is Annual/12 and isn't really worth much in this context.
DailyAmt is just Annual/365 (366 in a leap year) and is necessary for
partial month proration. I suppose I could create a date table for the
next 25 years with no 2/29's in it, and do my DATEDIFFs against that...
I was hoping to avoid the cursor thing...
Jody
Navigation:
[Reply to this message]
|