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