Try OpenEdge Now
skip to main content
ABL Reference
ABL Syntax Reference : WEEKDAY function
 

WEEKDAY function

Evaluates a date expression and returns the day of the week as an INTEGER value from 1 (Sunday) to 7 (Saturday) for that date.

Syntax

WEEKDAY ( date )
WEEKDAY ( datetime-expression )
date
A date expression for which you want the day of the week.
datetime-expression
An expression that evaluates to a DATETIME or DATETIME-TZ. The WEEKDAY function returns the weekday of the date part of the DATETIME or DATETIME-TZ value.

Example

This procedure tells you the day of the week that you were born and how many days old you are:
r-wkday.p
DEFINE VARIABLE birth-date AS DATE      NO-UNDO
LABEL "Birth Date".
DEFINE VARIABLE daynum     AS INTEGER   NO-UNDO.
DEFINE VARIABLE daylist    AS CHARACTER NO-UNDO FORMAT "x(9)"
INITIAL "Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday".
DEFINE VARIABLE dayname    AS CHARACTER NO-UNDO
LABEL "Day You Were Born".
DEFINE VARIABLE daysold    AS INTEGER   NO-UNDO
LABEL "Days Since You Were Born".

REPEAT:
SET birth-date.
  ASSIGN
    daynum  = WEEKDAY(birth-date)
    dayname = ENTRY(daynum, daylist)
    daysold = TODAY - birth-date.

DISPLAY dayname daysold.
END.

See also

ADD-INTERVAL function, DATE function, DATE-FORMAT attribute, DATETIME function, DATETIME-TZ function, DAY function, ETIME function, INTERVAL function, ISO-DATE function, MONTH function, MTIME function, NOW function, TIME function, TIME-SOURCE attribute, TIMEZONE function, TODAY function, YEAR function, YEAR-OFFSET attribute