KATER__IS_NOT_ON

Family: Date conditions

Syntax

1
KATER__IS_NOT_ON(field, value)

Arguments

Returns

TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.

Usage notes

• A row whose field is empty is left out too, since the comparison with an empty value is not true.

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.order_date AS "Order Date",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__IS_ON_OR_AFTER(orders.order_date, DATE '2026-09-27')
7
  AND KATER__IS_NOT_ON(orders.order_date, DATE '2026-09-28')
8
GROUP BY
9
  orders.order_date
10
ORDER BY
11
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
orders.order_date <> CAST('2026-09-28' AS DATE)

See also

• Filters and parameters
• Other functions in Date conditions: KATER__IS_AFTER, KATER__IS_BEFORE, KATER__IS_ON_OR_AFTER, KATER__IS_ON_OR_BEFORE, KATER__IS_ON, KATER__IS_WITHIN_LAST