Build-In Symbolic Constants.

<< Click to Display Table of Contents >>

Navigation:  Date / Time functions >

Build-In Symbolic Constants.

The macro language provides a number of predefined constants that can be used anywhere in your code in place of the actual values

 

Constant

Value

Description

vbSunday

1

Sunday (default).

vbMonday

2

Monday

vbTuesday

3

Tuesday.

vbWednesday

4

Wednesday.

vbThursday

5

Thursday

vbFriday

6

Friday.

vbSaturday

7

Saturday

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.