Function FISCALMONTH

TABLE OF CONTENTS

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

What is FISCALMONTH?

FISCALMONTH returns a month based on the fiscal values in the control record defined for a view. This means that different views running in the same batch 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.

The FISCALMONTH returns a date in CCYYMM format, based on the fiscal settings for the current view.

How do I use FISCALMONTH?

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

FISCALMONTH can only be used in Extract-Phase Logic.

(Syntax Legend)

Syntax

Function FISCALMONTH

Rules for the syntax

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

See also topic: Rules for all Logic Text

Examples: FISCALMONTH function in ERF

Example logic text Meaning
IF ({field2} >= FISCALMONTH(-1))
    THEN SELECT
ENDIF		 Select any input records where field2 is the previous fiscal month or later,
and skip all other records. Fiscal months means that if the date of
running this view is fiscal month one, then only records from
fiscal month one are selected.
The example at left assumes that field2 is a fiscal month number.
The code at left can also be written as:
SELECTIF({field2} >= FISCALMONTH(-1))

Examples: FISCALMONTH function in ECL

Example logic text Meaning
COLUMN = FISCALMONTH() Set the current column to the current fiscal month number.