SINCE, UNTIL and DURING

Every report runs over a date range. StockfulQL sets that range in one of two ways: a named range with DURING, or an explicit start and end with SINCE and UNTIL. Leave the date clause out entirely to read all of your history.

DURING

DURING picks a named calendar range. It is the quickest way to cover a whole period.

FROM sales
  SHOW total_revenue
  DURING last_month

Named ranges include today, yesterday, this_week, last_week, this_month, last_month, this_quarter, last_quarter, this_year, and last_year.

SINCE and UNTIL

SINCE sets the start of the range and UNTIL sets the end. Both take an operand that resolves to a date.

FROM sales
  SHOW total_revenue
  SINCE -30d UNTIL today

Operands can be:

Operand	Meaning
`2026-01-01`	An exact ISO date
`today` / `yesterday`	The current day, or the day before
`-30d`, `-12m`	A relative offset back from today (`d`, `w`, `m`, `q`, `y`)
`startOfDay(-90d)`	The start of a period N units ago
`endOfMonth(-1m)`	The end of a period N units ago

The period functions come in startOf... and endOf... forms over Day, Week, Month, Quarter, and Year. For example, SINCE startOfDay(-90d) UNTIL today covers the last ninety days.

FROM inventory
  SHOW inventory_value
  SINCE startOfMonth(-1m) UNTIL endOfMonth(-1m)

To compare the range against an earlier one, add COMPARE TO. To break the range into buckets over time, add TIMESERIES.

Introduction

Syntax

Datasets

Examples

SINCE, UNTIL and DURING

DURING

SINCE and UNTIL

​DURING

​SINCE and UNTIL

DURING

SINCE and UNTIL