Date Constants

The following constants can be used anywhere in your code in place of the actual values:

Argument Values

The firstdayofweekargument has the following values:

Constant Value Description
vbUseSystem 0 Use 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

The firstdayofyear argument has the following values:

Constant Value Description
vbUseSystem 0 Use NLS API setting.
VbUseSystemDayOfWeek 0 Use the day of the week specified in your system settings for the first day of the week.
VbFirstJan1 1 Start with week in which January 1 occurs (default).
vbFirstFourDays 2 Start with the first week that has at least four days in the new year.
vbFirstFullWeek 3 Start with the first full week of the year.

Return 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