Date and Time Constants

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.