> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://notion.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://notion.ferndocs.com/_mcp/server.

# Dates with times and timezones are now supported on Database Date Filters

Previously, the date filters `equals`, `after`, `before`, `on_or_after`, and `on_or_before` only supported dates without times nor timezones. 

**`JSON`**

```json JSON
{
    "filter": {
        "or": [
            {
                "property": "My Time Property",
                "date": {
                    "before": "2021-10-20"
                }
            }
        ]
    },
    "sorts": []
}
```
Now the database date filters can accept ISO 8601 dates with timestamps and timezones.

**`JSON`**

```json JSON
{
    "filter": {
        "or": [
            {
                "property": "My Time Property",
                "date": {
                    "before": "2021-10-15T12:00:00-07:00"
                }
            }
        ]
    },
    "sorts": []
}
```

<Info title="How Dates with times are compared">
Date time comparisons are done with millisecond precision. If no timezone is provided, the default is UTC.
</Info>

<Info title="Equals Date Filter">
If a date without a time is provided to the `equals`, the comparison is done against the start and end of the UTC date provided (inclusive). If a date with a time is provided, the comparison is done with millisecond precision. If no timezone is provided, the default timezone is UTC.
</Info>