Name
Weekday Function
Syntax
Weekday(date
, [firstdayofweek
])
-
date
Use: Required
Data Subtype: Variant
Any valid date expression.
-
firstdayofweek
Use: Optional
Data Subtype: Integer
Integer specifying the first day of the week.
Return Value
A Variant of subtype 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 |
---|---|---|
|
1 |
Sunday |
|
2 |
Monday |
|
3 |
Tuesday |
|
4 |
Wednesday |
|
5 |
Thursday |
|
6 |
Friday |
|
7 |
Saturday |
If
date
isNull
, theWeekday
function also returnsNull
.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 & Gotchas
If you specify a
firstdayofweek
argument, the function returns the day of the week relative tofirstdayofweek
. For instance, if you set the value offirstdayofweek
tovbMonday
(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 ...
Get VBScript in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.