# Date conditions

These conditions test a date or a timestamp.

{/* Written by apps/landing-page/scripts/docs/write_kater_functions.py from the compiler's function registry, kater_sql/function_docs.py and scripts/docs/sql-language.md. Do not edit it by hand: change those, then run the script. */}

Write a date value as `DATE '2026-01-31'`. See [Filters and parameters](https://kater.ai/docs/model/filters-and-parameters/).

| Function | What it does |
| --- | --- |
| [`KATER__IS_AFTER`](https://kater.ai/docs/sql-reference/functions/kater__is_after/) | True where the date is after the value. |
| [`KATER__IS_BEFORE`](https://kater.ai/docs/sql-reference/functions/kater__is_before/) | True where the date is before the value. |
| [`KATER__IS_ON_OR_AFTER`](https://kater.ai/docs/sql-reference/functions/kater__is_on_or_after/) | True where the date is on or after the value. |
| [`KATER__IS_ON_OR_BEFORE`](https://kater.ai/docs/sql-reference/functions/kater__is_on_or_before/) | True where the date is on or before the value. |
| [`KATER__IS_ON`](https://kater.ai/docs/sql-reference/functions/kater__is_on/) | True where the date is the value. |
| [`KATER__IS_NOT_ON`](https://kater.ai/docs/sql-reference/functions/kater__is_not_on/) | True where the date is not the value. |
| [`KATER__IS_WITHIN_LAST`](https://kater.ai/docs/sql-reference/functions/kater__is_within_last/) | True where the date is in the last few periods, counted back from today or from end. |

On this page

Kater SQL Functions Date conditions

Date conditions

These conditions test a date or a timestamp.

Write a date value as DATE '2026-01-31'. See Filters and parameters.

Function	What it does
`KATER__IS_AFTER`	True where the date is after the value.
`KATER__IS_BEFORE`	True where the date is before the value.
`KATER__IS_ON_OR_AFTER`	True where the date is on or after the value.
`KATER__IS_ON_OR_BEFORE`	True where the date is on or before the value.
`KATER__IS_ON`	True where the date is the value.
`KATER__IS_NOT_ON`	True where the date is not the value.
`KATER__IS_WITHIN_LAST`	True where the date is in the last few periods, counted back from today or from end.

Date conditions

Cookie notice