VBScript in a Nutshell, 2nd Edition

Name

DatePart Function

Syntax

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

interval

Use: Required

Data Type: String

The unit of time to extract from within date (see the following table “Interval Settings”).

date

Use: Required

Data Type: Date

The Date value that you want to evaluate.

firstdayofweek

Use: Optional

Data Type: Integer

A numeric constant that defines the first day of the week. If not specified, Sunday is assumed (see the following table “First Day of Week Constants”).

firstweekofyear

Use: Optional

Data Type: Integer

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 following table “First Week of Year Constants”).

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 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

An Integer.

Description

Extracts an individual component of the date or time (like the month or the second) from a date/time value. It ...