SINCE, UNTIL, DURING

Use SINCE and UNTIL, or DURING, to choose one reporting period for a ShopifyQL query. Use SINCE to set an explicit start boundary, and add UNTIL to set an explicit end boundary. Use DURING for a predefined reporting period, such as last_month or bfcm2025. Because DURING already defines the full reporting period, don't combine it with SINCE or UNTIL in the same query.

For SINCE and UNTIL, date parameters can use absolute, relative, named date ranges, or date functions. To compare the selected period to another period, use COMPARE TO.

Use SINCE to set the inclusive start of the reporting period. Add UNTIL to set the inclusive end. If you use SINCE without UNTIL, then ShopifyQL uses now as the end date.

If you use UNTIL without SINCE, then the query must include TIMESERIES so ShopifyQL can apply a default start date. If both boundaries resolve to dates or date-times, then the UNTIL boundary can't be before the SINCE boundary.

Use DURING when a named date range defines the full reporting period. DURING replaces explicit SINCE and UNTIL boundaries, so don't combine it with either clause.

DURING accepts named date ranges only and doesn't accept now. Use SINCE and UNTIL when you need now, an absolute date or date-time, a relative offset, or a date function as a boundary.

To compare the selected period with a relative period such as previous_period, use COMPARE TO.