 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
 |
 |
 |
|
||||||||||||||||||
 |
 |
 |
 |
 |
 |
 |
|
|||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Returns a whole number representing the day of the week.
Weekday(date, [firstdayofweek])
date
Any expression that can represent a date. If date contains Null, Null is returned.
firstdayofweek
A constant that specifies the first day of the week. If omitted, vbSunday is assumed.
The firstdayofweek argument has these settings:
|
Constant |
Value |
Description |
|
vbUseSystem |
0 |
Use National Language Support (NLS) API setting. |
|
vbSunday |
1 |
Sunday |
|
vbMonday |
2 |
Monday |
|
vbTuesday |
3 |
Tuesday |
|
vbWednesday |
4 |
Wednesday |
|
vbThursday |
5 |
Thursday |
|
vbFriday |
6 |
Friday |
|
vbSaturday |
7 |
Saturday |
The Weekday function can return any of these values:
|
Constant |
Value |
Description |
|
vbSunday |
1 |
Sunday |
|
vbMonday |
2 |
Monday |
|
vbTuesday |
3 |
Tuesday |
|
vbWednesday |
4 |
Wednesday |
|
vbThursday |
5 |
Thursday |
|
vbFriday |
6 |
Friday |
|
vbSaturday |
7 |
Saturday |
The following example uses the Weekday function to obtain the day of the week from a specified date:
Dim MyDate, MyWeekDay
MyDate = #October 19, 1962# ' Assign a date.
MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 6 because MyDate represents a Friday.
Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.