YearsAfter Function
Description:
The date which is so many whole years after the source date.
If the number of years is positive then the resultant date will be after the source date.
If the number of years is negative then the resultant date will be before the source date.
Returns:
Date
Parameters:
Parameter | Data Type | Description |
|---|---|---|
1 | Date | The source date. |
2 | Whole Number | The number of whole years. |
Example:
When using functions inside a field, remember the field brackets:
{YearsAfter(AgreementDate, TermInYears)}
Expression | Result |
|---|---|
YearsAfter( Date( 2000, 1, 15 ), 1 ) | Date( 2001, 1, 15 ) |