The following table shows the date and time constants you can use anywhere in your code in place of actual 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. |
vbFirstJan1 | 1 | Use the week in which January 1 occurs (default). |
vbFirstFourDays | 2 | Use the first week that has at least four days in the new year. |
vbFirstFullWeek | 3 | Use the first full week of the year. |
vbUseSystem | 0 | Use the date format contained in the regional settings for your desktop computer. |
vbUseSystemDayOfWeek | 0 | Use the day of the week specified in your system settings for the first day of the week. |