VBScript in a Nutshell, 2nd Edition

Name

Weekday Function

Syntax

Weekday(date, [firstdayofweek])

date

Use: Required

Data Type: Variant

Any valid date expression.

firstdayofweek

Use: Optional

Data Type: Integer

Integer specifying the first day of the week.

Return Value

An Integer.

Description

Determines the day of the week of a given date.

Rules at a Glance

• The following intrinsic VBScript constants determine the value returned by the Weekday function:

Constant	Return value	Day represented
vbSunday	1	Sunday
vbMonday	2	Monday
vbTuesday	3	Tuesday
vbWednesday	4	Wednesday
vbThursday	5	Thursday
vbFriday	6	Friday
vbSaturday	7	Saturday

• If date is Null, the Weekday function also returns Null.

• The following table describes the settings for the firstdayofweek argument:

Constant	Value	Description
vbUseSystem	0	Use the NLS API setting
vbSunday	1	Sunday (default)
vbMonday	2	Monday
vbTuesday	3	Tuesday
vbWednesday	4	Wednesday
vbThursday	5	Thursday
vbFriday	6	Friday
vbSaturday	7	Saturday

Programming Tips and Gotchas

• If you specify a firstdayofweek argument, the function returns the day of the week relative to firstdayofweek. For instance, if you set the value of firstdayofweek to vbMonday (2), indicating that Monday is the first day of the week, and attempt to determine the day of the week on which October 1, 1996, falls, the function returns a 2. That’s because October 1, 1996, is a Tuesday, the second day of a week whose first day is Monday.

• Because the function’s return value is relative to firstdayofweek, using the day of the week constants to interpret the function’s return value ...