Previous Topic: END Command-End a ReportNext Topic: EXITRTN Command-Define User Exits


EXCLUDE Command-Define Excluded Time Ranges

The EXCLUDE command defines time ranges to exclude from a report. You cannot use both INCLUDE and EXCLUDE commands in the same report. You can use multiple EXCLUDE commands to exclude multiple time ranges.

This command has the following syntax:

EXCLUDE [day] [time - time] [ID name]
        [date]
        [date time - date time]
        [month]
day

Specifies the day of the week. Valid values are: SUNday, MONday, TUESday, WEDnesday, THURsday, FRIday, or SATurday.

time

Specifies the time of day in hh:mm:ss format.

date

Specifies the date in mm/dd/yy format.

ID name

Defines a name to be associated with a specific setting of the EXCLUDE command, for use with the SELECT variable option.

For more information, see the SELECT variable option in the chapter “Tabular Reports” and the SELECT operand of the COST Command in this chapter.

month

Specifies the month. Valid values are: JANuary, FEBruary, MARch, APRil, MAY, JUNe, JULy, AUGust, SEPTember, OCTober, NOVember, or DECember

Example: EXCLUDE Command

EXCLUDE SUNDAY

EXCLUDE 02/04/11

EXCLUDE 12:00:00 - 13:00:00

EXCLUDE FRIDAY 16:00:00 - 17:00:00

EXCLUDE 08:00:00 - 15:59:59 ID 1STSHIFT
EXCLUDE 16:00:00 - 23:59:59 ID 2NDSHIFT

EXCLUDE JULY