Function YEARSBETWEEN

TABLE OF CONTENTS

  1. What is YEARSBETWEEN?
  2. Syntax
  3. Rules for the syntax
  4. Examples: YEARSBETWEEN function in ERF
  5. Examples: YEARSBETWEEN function in ECL

What is YEARSBETWEEN?

Use YEARSBETWEEN to compare dates and give the difference in years.

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

(Syntax Legend)

Syntax

Function RUNYEAR 1

Function RUNYEAR 2

Function RUNYEAR 3

Function RUNYEAR 4

Function RUNYEAR 5

Rules for the syntax

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

See also topic: Rules for all Logic Text

Examples: YEARSBETWEEN function in ERF

Example logic text Meaning
IF ({field4} = RUNYEAR(-1))
    THEN SELECT
ENDIF		 Select any input records where field4 is the previous year,
and skip all other records.
The example at left assumes that field4 is a year number.
The code at left can also be written as:
    SELECTIF({field4} = RUNYEAR(-1))
IF (YEARSBETWEEN({field1},{field2}) >= 1)
    THEN SELECT
ENDIF		 Select only records where there is at least one year
between field1 and field2, and skip all other records.
This example can also be written:
    SELECTIF(YEARSBETWEEN({field1},{field2}) >= 1)

Examples: YEARSBETWEEN function in ECL

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