Function MONTHSBETWEEN

TABLE OF CONTENTS

  1. How do I use MONTHSBETWEEN?
  2. Syntax
  3. Rules for the syntax
  4. Examples: MONTHSBETWEEN function in ERF
  5. Examples: MONTHSBETWEEN function in ECL

How do I use MONTHSBETWEEN?

Use MONTHSBETWEEN to compare dates and return the difference in months.

MONTHSBETWEEN can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

(Syntax Legend)

Syntax

Function MONTHSBETWEEN 1

Function MONTHSBETWEEN 2

Function MONTHSBETWEEN 3

Function MONTHSBETWEEN 4

Rules for the syntax

MONTHSBETWEEN can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

See also topic: Rules for all Logic Text

Examples: MONTHSBETWEEN function in ERF

Example logic text Meaning
IF (MONTHSBETWEEN({field1},{field2}) >= 3)
    THEN SELECT
ENDIF		 Select only records where there are at least 3 months between field1 and field2,
and skip all other records.
This example is the same as:
    SELECTIF(MONTHSBETWEEN({field1},{field2}) >= 3)

Examples: MONTHSBETWEEN function in ECL

Example logic text Meaning
COLUMN = MONTHSBETWEEN({BUY_DATE},{SHIP_DATE}) Set the current column to the months between
the transaction date and the shipping date.
IF (MONTHSBETWEEN({BUY_DATE},{SHIP_DATE}) > 1)
    THEN COLUMN = {SHIP_DATE}
    ELSE COLUMN = {BUY_DATE}
ENDIF		 If there is more than one month between the transaction date and the shipping date,
then set the current column to the shipping date,
otherwise set the current column to the transaction date.
IF (MONTHSBETWEEN({BUY_DATE},{SHIP_DATE})> 6)
    THEN WRITE(SOURCE=VIEW,DEST=EXT=03)
ENDIF		 Write to extract 3 those records where
there are more than 6 months between the
transaction date and the shipping date.