Function DATE

TABLE OF CONTENTS

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

How do I use DATE?

DATE is used whenever you want to specify a date with a date format. You can use DATE to set a value, or as part of a comparison.

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

(Syntax Legend)

Syntax

(Function DATE 1)

(Function DATE 2)

(Function DATE 3)

(Function DATE 4)

Rules for the syntax

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

See also topic: Rules for all Logic Text

Examples: DATE function in ERF

Example logic text Meaning
IF {field1} = DATE(“20111201”,CCYYMMDD)
    THEN SELECT
ENDIF		 Select those input records where
field1 is December 1, 2011.
The code can also be written as:
    SELECTIF({field1}= DATE(“20111201”,CCYYMMDD))

Examples: DATE function in ECL

Example logic text Meaning
COLUMN = DATE(“20111201”,CCYYMMDD) Set the current column to a date of
December 1, 2011 in CCYYMMDD format.