CAS 6

daysdiffbusinessbond
- Date

Summary

Subtract business days using the US Bond Market calendar.

Description

Get business days difference between two valid dates using the US Bond market calendar.

Invalid dates always return -999999.

If Start Date > End Date, and Start Date is not a Bond Market Business day, then Start Date moves to the previous Bond Market Business Day.

If Start Date < End Date, and Start Date is not a Bond Market Business day, then Start Date moves to the next Bond Market Business Day.

The result includes the End Date, but not the Start Date.

Examples

daysdiffbusinessbond DATE_FIELD 20210112
daysdiffbusinessbond DATE_FIELD1 DATE_FIELD2
daysdiffbusinessbond 20210805 20210804
daysdiffbusinessbond 20210807 20210806
daysdiffbusinessbond 20210809 20210806
daysdiffbusinessbond 20210807 20210731

Syntax

daysdiffbusinessbond StartDate EndDate

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
StartDate	Date	Field, Constant	Start Date	No
EndDate	Date	Field, Constant	End Date	No

Result

Type: Integer

Business days difference.