Table of Contents

, ,

MONTH_ADD

Description

Returns the date resulting from adding/subtracting the specified number of months to the specified date

Syntax

MONTH_ADD (date, months)

Can be used in the condition of a FIND action.

Parameters

An expression producing date and an expression producing a number to be added or subtracted (if the number is negative) to the date

Returns

Date: the date moved forward by the number of months (back if the number is negative).

Example

 IF MONTH_ADD (Account.OpeningDate, 4) = 07/04/2004 THEN ... 

DATE_ADD, TIME_ADD, MONTH_DIFFERENCE