PowerScript Reference
PowerScript Functions

Description

Determines the day of the week of a date value and returns the number of the weekday.

Syntax

DayNumber ( date )

Return value

Integer.

Returns an integer (1-7) representing the day of the week of date. Sunday is day 1, Monday is day 2, and so on. If date is null, DayNumber returns null.

Examples

These statements evaluate the date literal 2000-01-31 and set day_nbr to 4 (January 31, 2000, was a Wednesday):

integer day_nbr
day_nbr = DayNumber(2000-01-31)

These statements check to be sure the date in sle_date is valid, and if so set day_nbr to the number of the day in the sle_date:

integer day_nbr
 
IF IsDate(sle_date.Text) THEN
    day_nbr = DayNumber(Date(sle_date.Text))
ELSE
    MessageBox("Error", &
    "This date is invalid: " &
    + sle_date.Text)
END IF

See also

Day

DayName

IsDate

DayNumber method for DataWindows in the section called “DayNumber” in DataWindow Reference.