> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# day_of_week

> Filters time fields by the day of the week.

Filters time fields by the day of the week. Returns rows where the date falls on the specified day of the week.

## Syntax

```yaml theme={null}
<time_field>:
  day_of_week: "<day>"
```

## Properties

<ParamField path="time_field" type="string" required>
  The time/date field to filter on, specified in the format `view_name.field_name`.
</ParamField>

<ParamField path="day_of_week" type="string" required>
  The day of the week to filter for. The value can be either the full name of the day or a number:

  * `0` - `Sunday`
  * `1` - `Monday`
  * `2` - `Tuesday`
  * `3` - `Wednesday`
  * `4` - `Thursday`
  * `5` - `Friday`
  * `6` - `Saturday`
</ParamField>

## Examples

```yaml title="Day of week is Monday" theme={null}
users.created_at:
  day_of_week: "Monday"
```

```yaml title="Day of week is not Sunday" theme={null}
users.created_at:
  not_day_of_week: "0"
```