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 |