WeekdayName

Retrieve the name of the weekday corresponding to a numeric value.

SELECT WeekdayName(3);

Definition and Usage

The WeekdayName() function retrieves the weekday name based on a numeric value.

WeekdayName(number, abbreviate, firstdayofweek)

Parameter	Description
number	Required. A numeric value ranging from 1 to 7, representing the day of the week.
abbreviate	Optional. A Boolean parameter where: True indicates the weekday name should be abbreviated. False (default) indicates the weekday name should not be abbreviated.
firstdayofweek	Optional. Specifies the starting day of the week with the following options: 0: Use the NLS API setting 1: Sunday (default) 2: Monday 3: Tuesday 4: Wednesday 5: Thursday 6: Friday 7: Saturday

WORKS IN

From Access 2000

Retrieve the abbreviated weekday name corresponding to a numeric value.

SELECT WeekdayName(3, true);

Retrieve the abbreviated weekday name based on a numeric value, using Monday as the first day of the week.

SELECT WeekdayName(3, true, 2);