Weekday Function |
Yes
Weekday(date, [firstdayofweek])
date
Use: Required
Data Type: Variant
Any valid date expression.
firstdayofweek
Use: Optional
Data Type: Integer
Constant value specifying the first day of the week.
A Variant of subtype Integer.
Determines the day of the week of a given date.
The following intrinsic 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 possible 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 |
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.
The fact that the function's return value is relative to firstdayofweek makes using the day of the week constants to interpret the function's return value confusing, to say the least. If we use our October 1, 1996, example once again, the following expression evaluates to True if the day of the week is Tuesday:
If vbMonday = WeekDay(CDate("10/1/96"), vbMonday) Then