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

Weekday Function

Syntax

Weekday(date, [firstdayofweek])
date

Use: Required

Data Subtype: Variant

Any valid date expression.

firstdayofweek

Use: Optional

Data Subtype: Integer

Integer specifying the first day of the week.

Return Value

A Variant of subtype Integer.

Description

Determines the day of the week of a given date.

Rules at a Glance

  • The following intrinsic VBScript constants determine the value returned by the Weekday function:

Constant

Return Value

Day Represented

vbSunday

1

Sunday

vbMonday

2

Monday

vbTuesday

3

Tuesday

vbWednesday

4

Wednesday

vbThursday

5

Thursday

vbFriday

6

Friday

vbSaturday

7

Saturday

  • If date is Null, the Weekday function also returns Null.

  • The following table describes the settings for the firstdayofweek argument:

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

Programming Tips & Gotchas

  • If you specify a firstdayofweek argument, the function returns the day of the week relative to firstdayofweek. For instance, if you set the value of firstdayofweek to vbMonday (2), indicating that Monday is the first day of the week, and attempt to determine the day of the week on which October 1, 1996, falls, the function returns a 2. That’s because October 1, 1996, is a Tuesday, the second day of a week whose first day is Monday.

  • Because the function’s ...

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