Days360 Function

Days360 Function

Description:
The number of whole days between a start date and a finish date. The calculation is based upon a 360-day year comprising twelve 30-day months. If the start date is before the finish date then the number of days between is positive. If the start date is after the finish date then the number of days between is negative.
Returns:
Whole Number
Parameters:
Parameter
Data Type
Description
1
Date
The start date.
2
Date
The finish date.
Examples:
When using functions inside a field, remember the field brackets:
{Days360(AgreementDate, TerminationDate)}
Expression
Result
Days360( Date( 1999, 2, 28 ), Date( 2000, 2, 27 ) )
359
Days360( Date( 1999, 2, 28 ), Date( 2000, 2, 28 ) )
360
Days360( Date( 1999, 2, 28 ), Date( 2000, 2, 29 ) )
361