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

This article applies to: