DayOfWeek

The DayOfWeek() function returns the day of the week. Monday is day 1 and Sunday is day 7.

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.

Syntax

DayOfWeek(date)

DayOfWeek('1966-08-07') =>Result: 7

DayOfWeek(UnknownDateTime) =>Result: (unknownNumber)

Parameters

Name	Type	Required	Description
date	date time	☑️	a date