MonthsAfter Function
Description:
The date which is so many whole months after the source date.
If the number of months is positive then the resultant date will be after the source date.
If the number of months 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 months after. |
Examples:
When using functions inside a field, remember the field brackets:
{MonthsAfter(AgreementDate, EvaluationMonths)}
Expression | Result |
|---|---|
MonthsAfter( Date( 2000, 1, 11 ), 1 ) | Date( 2000, 2, 11 ) |
MonthsAfter( Date( 2000, 1, 31 ), 1 ) | Date( 2000, 2, 29 ) |
MonthsAfter( Date( 2000, 2, 29 ), 12 ) | Date( 2001, 2, 28 ) |