|
Weekday Function |
Main Menu |
The Weekday function syntax has these arguments:
| Part | Description |
| 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. |
Settings
The firstdayofweek argument has these settings:
| Constant | Value | Description |
| vbUseSystem | 0 | Use NLS API setting. |
| vbSunday | 1 | Sunday |
| vbMonday | 2 | Monday |
| vbTuesday | 3 | Tuesday |
| vbWednesday | 4 | Wednesday |
| vbThursday | 5 | Thursday |
| vbFriday | 6 | Friday |
| vbSaturday | 7 | Saturday |
Return Values
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 |
Remarks
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.
related to
Date Day
Month Now Year
|