> ## 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.

# before

> Filters time fields for dates before a specified date.

Filters time fields for dates before a specified date. Returns rows where the date is less than the specified date.

## Syntax

```yaml theme={null}
<time_field>:
  before: <date>
```

## 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="before" type="string | date" required>
  The date threshold. Returns rows where the field value is less than this date. Can be:

  * **Fixed date** - Specified in `YYYY-MM-DD` format. For example, `2024-01-01`.
  * **Relative date** - For example, `today`, `7 days ago`
</ParamField>

## Examples

```yaml title="Date is before January 1, 2024" theme={null}
users.created_at:
  before: 2024-01-01
```

```yaml title="Date is before today's date" theme={null}
orders.order_date:
  before: today
```