DaysBetween Function
Description:
The number of whole days between the start date and the finish date.
If the finish date is after the start date then the number of days between them will be positive.
If the finish date is before the start date then the number of days between them will be negative.
Returns:
Date
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Date | The start date. |
2 | Date | The finish date. |
Example:
When using functions inside a field, remember the field brackets:
{DaysBetween(AgreementDate, AgreementReviewDate)}
Expression | Result |
|---|---|
DaysBetween( Date( 1999, 12, 31 ), Date( 2000, 2, 29 ) ) | 60 |
Related Content
-
Date Functions
Format:
Article,
1 min read