THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Weekday() Function

❮ MS Access Functions

Example

Return the weekday number for a date:

SELECT Weekday(#05/17/2017#);
Try it Yourself »

Definition and Usage

The Weekday() function returns the weekday number for a given date.

This function returns an integer between 1 and 7.

Syntax

Weekday(date, firstdayofweek)

Parameter Values

Parameter Description
date Required. A valid date
firstdayofweek Optional. Specifies the first day of the week. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Sunday (default)
  • 2 = Monday
  • 3 = Tuesday
  • 4 = Wednesday
  • 5 = Thursday
  • 6 = Friday
  • 7 = Saturday

Technical Details

Works in: From Access 2000

More Examples

Example

Return the weekday number for the current date:

SELECT Weekday(Date());
Try it Yourself »

Example

Return the weekday number for the specified date, setting Monday as the first day of week:

SELECT Weekday(#05/17/2017#, 2);
Try it Yourself »

❮ MS Access Functions