THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access WeekdayName() Function

❮ MS Access Functions

Example

Return the weekday name based on a given number:

SELECT WeekdayName(3);

Definition and Usage

The WeekdayName() function returns the weekday name given a number from 1 to 7.

Syntax

WeekdayName(number, abbreviate, firstdayofweek)

Parameter Values

Parameter Description
number Required. A number (from 1 to 7) that represent a day of the week
abbreviate Optional. True means that the weekday name is abbreviated. False means that the weekday name is not abbreviated. False is default
firstdayofweek Optional. Specifies the first day of the week. If omitted, Sunday is the first day of the week. Can be one of the following values:
  • 0 = Use the NLS API setting
  • 1 = Sunday
  • 2 = Monday
  • 3 = Tuesday
  • 4 = Wednesday
  • 5 = Thursday
  • 6 = Friday
  • 7 = Saturday

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

More Examples

Example

Return the abbreviated weekday name based on a given number:

SELECT WeekdayName(3, true);

Example

Return the abbreviated weekday name based on a given number, setting Monday as the first day of week:

SELECT WeekdayName(3, true, 2);

❮ MS Access Functions