Function FISCALDAY

TABLE OF CONTENTS

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

What is FISCALDAY?

FISCALDAY returns a day based on the fiscal values in the control record defined for the view. This means that different views in the same batch run can have different fiscal dates. By comparison, RUNDAY is the same for all views in a batch.

You can override the fiscal date(s) with the extract job parameters FISCAL_DATE_DEFAULT and FISCAL_DATE_OVERRIDE. See GVBMR95 parameters.

FISCALDAY returns a date in CCYYMMDD format, based on the fiscal settings for the current view.

How do I use FISCALDAY?

The parameter for FISCALDAY is a number of days to add or subtract from the default FISCALDAY. For example, FISCALDAY(-5) provides the day that is five days before the date the view is run.

FISCALDAY can only be used in Extract-Phase Logic.

(Syntax Legend)

Syntax

Function FISCALDAY

Rules for the syntax

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

See also topic: Rules for all Logic Text

Examples: FISCALDAY function in ERF

Example logic text Meaning
IF ({field1} < FISCALDAY(-7))
    THEN SKIP
ENDIF		 Skip any input records where field1 is more than 7 fiscal days before
the date of running this view, and select all other records.
Fiscal days means that if the date of running this view is fiscal day five
of a fiscal year, then only records from fiscal days one to five
are selected. This example assumes that field1 is a fiscal day number.
The code at left can also be written as
    SKIPIF({field1} < FISCALDAY(-7))

Examples: FISCALDAY function in ECL

Example logic text Meaning
COLUMN = FISCALDAY() Set the current column to the
fiscal day number of the day
the view is run.