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

DateDiff Function

Syntax

                  
                  DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
interval

Use: Required

Data Subtype: String

The units of time used to express the result of the difference between date1 and date2 (see the following “Interval Settings” table).

date1

Use: Required

Data Subtype: Date

The first date you want to use in the differential calculation.

date2

Use: Required

Data Subtype: Date

The second date you want to use in the differential calculation.

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

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