KATER__IS_ON_OR_BEFORE

Family: Date conditions

Syntax

1
KATER__IS_ON_OR_BEFORE(field, value)

Arguments

Returns

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

Usage notes

• On a timestamp, a date value is midnight at the start of that day. So a later time on that day is not on or before it.

Example

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

1
SELECT
2
  orders.order_month AS "Order Month",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__IS_ON_OR_BEFORE(orders.order_date, DATE '2025-03-31')
7
GROUP BY
8
  orders.order_month
9
ORDER BY
10
  1

Compiles to

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

1
orders.order_date <= CAST('2025-03-31' 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, KATER__IS_NOT_ON, KATER__IS_WITHIN_LAST