MonthsBefore Function

Description:

The date which is so many whole months before the source date.

If the number of months is positive then the resultant date will be before the source date.

If the number of months is negative then the resultant date will be after the source date.

Returns:

Date

Parameters:

Parameter	Data Type	Description
1	Date	The source date.
2	Whole Number	The number of whole months before.

Example:

When using functions inside a field, remember the field brackets:

{MonthsBefore(FinanceEndTerm, 1)}

Expression	Result
MonthsBefore( Date( 2000, 2, 29 ), 12 )	Date( 1999, 2, 28 )

This article applies to: