AccruableDays
Mon 01 January 2018Syntax
AccruableDays(StartDate, EndDate, Accrual_Conv)
Description
Use the AccruableDays function to return the number of days during which interest can accrue in a given range of time according to the Accrual_Conv parameter.
Parameters
|
Field or Control |
Definition |
|---|---|
| StartDate |
The beginning of the time period for determining the accrual. This parameter takes a date value. |
| EndDate |
The end of the time period for determining the accrual. This parameter takes a date value. |
| Accrual_Conv |
The accrual convention. This parameter takes either a number or a constant value. Values for this parameter are: |
|
Numeric Value |
Constant Value |
Description |
|---|---|---|
|
0 |
%Accrual_30DPM |
30/360: all months 30 days long according to NASD rules for date truncation |
|
1 |
%Accrual_30DPME |
30E/360: all months 30 days long according to European rules for date truncation |
|
2 |
N/A |
30N/360: all months but February are 30 days long according to SIA rules |
|
3 |
%Accrual_Fixed360 |
Act/360: months have variable number of days, but years have fixed 360 days |
|
4 |
%Accrual_Fixed365 |
Act/365: months have variable number of days, buy years have fixed 365 days |
|
5 |
%Accrual_ActualDPY |
Act/Act: months and years have a variable number of days |
Returns
An integer representing a number of days.