Name

DatePart Function

Syntax

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

Use: Required

Data Subtype: String

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

date

Use: Required

Data Subtype: Date

The Date value that you want to evaluate.

firstdayofweek

Use: Optional

Data Subtype: Numeric constant

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 Subtype: 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 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 ...

Get VBScript in a Nutshell now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.