Search…
Resources
Related Links
weekday
To return the weekday of a given date value as a number
With this function, you can determine the corresponding weekday from a date value.
The weekday is a number with Monday = 0, Tuesday = 1, ... Sunday = 6.
Therefore, you can check if a particular date should be a workday (for example Monday to Friday) or a weekend day.
Note: It's not taking specific holidays into account.
You can use all data types containing a date.

Syntax

weekday(date)
weekday(timestamp)
weekday(appointment)

Return

number

Examples

weekday(date(2021, 12, 31))
Result: 4 (for “Friday”)
​
weekday(today())
Result: 4 (for “Friday” on Dec 31, 2021)
​
if weekday(date1) > 4 then "Weekend" else "Business day" end;
Result: “Weekend” (on May 1, 2021) with “date1” being a field in your table.

See also

​weedayIndex, which returns a given weekday name as a number.
​weekdayName, which returns the full weekday name of a given date value.
Last modified 2mo ago
Export as PDF
Copy link