Built-in Functions › WEEKDAY

WEEKDAY

Purpose

Returns the weekday (Monday, Tuesday, etc.) of a specified date.

Weekday functions can be coded in two ways, as shown in the syntax diagrams below.

Syntax

Format 1:

►►───┬─ WEEKDAY ──┬─ ( date, date-format ) ───────────────────────────────────►◄
     └─ WEEKDAYX ─┘

Format 2:

►►───┬─ GWEEKDAY ──┬─ ( date ) ───────────────────────────────────────────────►◄
     ├─ GWEEKDAYX ─┤
     ├─ CWEEKDAY ──┤
     ├─ CWEEKDAYX ─┤
     ├─ EWEEKDAY ──┤
     ├─ EWEEKDAYX ─┤
     ├─ JWEEKDAY ──┤
     └─ JWEEKDAYX ─┘

Parameters

Format 1:

WEEKDAY/WEEKDAYX

Invokes the weekday function. WEEKDAYX operates on dates that contain the century portion of the year.

date

A numeric value that specifies the input date. Date can be:

• The date, enclosed in quotation marks
• The name of a user-defined variable data field containing the date

date-format

Specifies the format of the date specified by date. Date-format can be:

• The date format, enclosed in quotation marks
• The name of a user-defined variable data field containing the date format

Date-format can be:

• C for calendar
• E for European
• G for Gregorian
• J for Julian

Format 2:

GWEEKDAY/GWEEKDAYX

CWEEKDAY/CWEEKDAYX

EWEEKDAY/EWEEKDAYX

JWEEKDAY/JWEEKDAYX

The invocation names of the alternate formats of the weekday function. The prefix C, E, G, or J of an invocation name identifies the format of the date specified by date (calendar, European, Gregorian, or Julian.)

Invocation names ending in X operate on dates that contain the century portion of the year.

date

A numeric value that specifies the input date. Date can be:

• The name of a user-defined variable data field
• A user-supplied numeric literal

Example 1 (Format 1)

In the following example, the weekday function is used to determine on which weekday January 28, 1958 fell. The date is provided in calendar format:

Statement:
    MOVE WEEKDAY(012858,'C') TO WK-RESULT.
Returned value: 'TUESDAY'

Example 2 (Format 1)

This example returns the weekday for a date that contains the century portion of the year:

Statement:
    MOVE WEEKDAYX(01281958,'C') TO WK-RESULT.
Returned value: 'TUESDAY'

Example 3 (Format 2)

This is equivalent to Example 2:

Statement:
    MOVE CWEEKDAY(01281958) TO WK-RESULT.
Returned value: 'TUESDAY'