Table of Contents

, ,

MONTH_DIFFERENCE

Description

Calculates the month difference between the two dates as an integer constant

Syntax

MONTH_DIFFERENCE (date1, date2)

Can be used in the condition of a FIND action.

Parameters

Two attributes of the Date type or date constants or calculations producing a date

Returns

Number: the difference in months between the two dates, as an integer.

Example

IF MONTH_DIFFERENCE (Account.OpeningDate, Account.ClosingDate) = 5 THEN ... 

MONTH_DIFFERENCE2, DAY_DIFFERENCE, WEEK_DIFFERENCE, YEAR_DIFFERENCE