The DayOfWeek() function returns the day of the week. Monday is day 1 and Sunday is day 7.
DayOfWeek()
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a number that represents the day of a week where 1 is Monday, 2 is Tuesday, etc.
Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.
Unknown
DayOfWeek(
date
)
DayOfWeek('1966-08-07') =>Result: 7
DayOfWeek('1966-08-07')
DayOfWeek(UnknownDateTime) =>Result: (unknownNumber)
DayOfWeek(UnknownDateTime)
date time
☑️
a date
Last updated 3 years ago
Was this helpful?
