VB & VBA in a Nutshell: The Language

DatePart Function

Named Arguments

Yes

Syntax

DatePart(interval, date[,firstdayofweek[, _
        firstweekofyear]])

interval

Use: Required

Data Type: String

The unit of time to extract from within date (see the table Section 7.54.3).

date

Use: Required

Data Type: Variant (Date)

The Date value that you want to evaluate.

firstdayofweek

Use: Optional

Data Type: Numeric constant

A numeric constant that defines the first day of the week. If not specified, Sunday is assumed (see the table Section 7.54.4).

firstweekofyear

Use: Optional

Data Type: Numeric constant

A numeric constant that defines the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs (see the table Section 7.54.5).

Interval Settings

Setting	Description
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second

First Day of the Week Constants

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

First Week of Year Constants

Constant	Value	Description
vbUseSystem	0	Use the NLS API setting.
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 first full week of the year.

Return Value

Variant (Integer)

Description

Extracts an ...