WEEKDAY
Returns a number representing the day of the week of the date provided
Usage examples
-
WEEKDAY("1/5/2010") -
WEEKDAY(tableA.fieldB)
Syntax
WEEKDAY ( date_serial_num, [ return_type ] )
-
date_serial_num- the date for which to determine the day of the week -
return_type- a number indicating which numbering system to use to represent weekdays, by default counts starting with Sunday = 1
Returns
number - the number representing the day of the week.