DAYWEEK

Returns the numbered weekday for the specified date value.

Syntax

DAYWEEK(dateval)

Example

If mydatefield has value '2024-10-30 09:55:00' (Wednesday), then:

DAYWEEK({{mydatefield}})

returns: 3

Notes

Values are 0 through 6 for Sunday through Saturday

Related

DAYYEAR
WEEKYEAR