Access: Weekday Function

In Access, the Weekday function returns a number representing the day of the week (a number from 1 to 7) given a date value.

The syntax for the Weekday function is:

Weekday ( date_value, [firstdayofweek] )

date_value is a valid date.

firstdayofweek is optional. It determines what day is to be the first day of the week. It can be any of the following values:

Constant Value Explanation

vbUseSystem 0 Use the NLS API settings

vbSunday 1 Sunday (default used)

vbMonday 2 Monday

vbTuesday 3 Tuesday

vbWednesday 4 Wednesday

vbThursday 5 Thursday

vbFriday 6 Friday

vbSaturday 7 Saturday

If this parameter is omitted, the Weekday function assumes that the first day of the week is Sunday.

Please note that if you use the Weekday function in a query, you'll have to use the numeric value (ie: 0 to 7) for the firstdayofweek parameter. You can only use the constant equivalent (ie: vbSunday to vbSaturday) in VBA code.

For example:

Weekday (#22/11/2003#) would return 7

Weekday (#22/11/2003#, vbThursday) would return 3

Weekday (#22/11/2003#, 5) would return 3

Weekday (#01/01/1998#) would return 5

VBA Code

The Weekday function can be used in VBA code. For example:

Dim LWeekday As Integer

LWeekday = Weekday(#12/03/2001#, vbSunday)

In this example, the variable called LWeekday would now contain the value of 2.

SQL/Queries

You can also use the Weekday function in a query.