The Date Range control in the report toolbar narrows a List multi-source report to rows whose date falls inside a window, before the report generates. A narrower report generates faster and stays under the row limit.
Choose a range
Open the Date Range control in the report toolbar and pick one of these:
A fixed range, with a start date, an end date, or both.
A calendar period: today, this week, last week, this month, last month, this quarter, last quarter, this year, or last year.
A rolling range of the last N days or the next N days.
Once a range is set, a chip in the toolbar shows it. For a rolling range or calendar period, the chip and the picker show the dates it covers, for example "This quarter · Oct 1 – Dec 31, 2026 (Pacific Time)".
Rolling ranges and calendar periods are recalculated every time the report generates, so "Last 7 days" always means the 7 days ending today. "Last 1 day" is the same as "Today". Weeks run Sunday to Saturday.
Time zone
Dates are read in the workspace's reporting time zone, which is US Pacific for every workspace. "Today" is the calendar day in that zone, and the chip and picker name the zone, for example "(Pacific Time)".
A value stored with a time and a time zone or offset (such as
2024-03-15T03:00:00Z) is converted to Pacific time before the day is compared.A value stored as a date only, or as a date and time with no zone, keeps its written day.
The report grid shows these values in your browser's time zone. If you are outside Pacific time, a value close to midnight can show a different day in the grid than the one the range used.
Which values match
A date range matches ISO dates (like 2026-10-28), ISO dates with a time, Unix timestamps in seconds or milliseconds, and /Date(ms)/ values.
Dates stored as free text, such as
10/28/2026, never match a range, because the day and month order is ambiguous. Impossible dates also never match.
A range that matches no rows produces an empty report, not an error.
Row limit errors
If a List report would include more rows than the maximum, generating it fails and the error suggests narrowing it with a date range. Set a range, then generate the report again.