KATER__IS_WITHIN_LAST

Family: Date conditions

Syntax

1
KATER__IS_WITHIN_LAST(field, amount, unit [, complete => TRUE] [, end => date])

Arguments

Required

Optional

Returns

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

Usage notes

• Without complete or end, it keeps the dates from today minus amount units. It has no upper end, so a date after today is kept too.
• With complete => TRUE, it keeps amount whole periods before the current one. In May, 3 months keeps February, March and April.
• With end, it keeps the dates after end minus amount units, up to and including end.
• With both, it keeps amount whole periods before the period that holds end. Set end to the day after the last day with data, and a month with all its data counts as complete.
• Today is the warehouse’s CURRENT_DATE, or CURRENT_TIMESTAMP for minute and hour, in the time zone of the warehouse session.
• A parameter can give amount. You write unit, complete and end in the call.

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_WITHIN_LAST(orders.order_date, 3, 'month', complete => TRUE, end => DATE '2026-10-01')
7
GROUP BY
8
  orders.order_month
9
ORDER BY
10
  1

Compiles to

1
orders.order_date >= DATE_TRUNC('MONTH', CAST('2026-10-01' AS DATE)) + INTERVAL (-3) MONTH
2
AND orders.order_date < DATE_TRUNC('MONTH', CAST('2026-10-01' AS DATE))

1
orders.order_date >= DATEADD(MONTH, -3, DATE_TRUNC('MONTH', CAST('2026-10-01' AS DATE)))
2
AND orders.order_date < DATE_TRUNC('MONTH', CAST('2026-10-01' 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_NOT_ON