Built-in Functions → weekday
weekday() is a scalar date function that returns the day number of the week from a date or time string. The function returns an integer associated with the day of the week, with 1 representing Sunday.
The following table illustrates the weekday() parameter:
|date exp||an expression evaluating to a |
Return the day number from July 7, 2014 at midnight.
This example returns 2 for Monday.