Function DateDifferenceDays(FirstDate, SecondDate, Basis)

DateDifferenceDays

The function DateDifferenceDays calculates the number of days between two dates based on the specified day count basis.

DateDifferenceDays(
    FirstDate,             ! (input) scalar string expression
    SecondDate,            ! (input) scalar string expression
    [Basis]                ! (optional) numerical expression
    )

Arguments

FirstDate

The first date must be in date format.

SecondDate

The second date must be in date format, and later than FirstDate.

Basis

The day-count basis method to be used. The default is 1.

Return Value

The function DateDifferenceDays returns the number of days between the two dates.

Note

The function DateDifferenceDays is similar to the Excel function DAYS300.

See also

Day count basis methods.