O'Reilly logo

VBScript in a Nutshell by Ron Petrusha, Paul Lomax, Matt Childs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required