Previous Topic: CREDIT Statement

Next Topic: DEBIT Statement

CRITERIA Statement

This statement, identified by the statement type CRITERIA, is optional. It provides a mechanism for selecting or rejecting input by date for processing by the Wizard Report Writer. You can establish a selection/rejection date range as follows:

DATE i ffffffff ssssssss

DATE

is the required keyword.

i

is the select (I = ) or reject (I = 1) indicator.

ffffffff

is the first date, the range beginning.

ssssssss

is the second date. If the second date is omitted, it defaults to the first date, in effect selecting or rejecting a single date.

If the CRITERIA statement is omitted, all input is processed. An extension to the record selection/rejection capability at the report level is available through the use of the grouping feature. This function is controlled by the GROUP and GROUPC statements which are discussed in detail later in this chapter.

Statement Position

Field Length

Field Name

Notes

1

1

Reserved

Must be blank

2-9

8

Statement Type

CRITERIA

10-13

4

Keyword

DATE

14

1

Select/Reject Indicator

1 = reject
= select

15-22

8

First Date

Range beginning date*

23-30

8

Second Date

Range ending date* (optional if same as range beginning date)

* Dates must be entered in the format MM/DD/YY

Dates specified with a year value of 00 through 59 are treated as year 2000 through 2059, and are considered logically greater than year values of 60 through 99 (1960 through 1999).