Skip to main content
Get Started
Documentation

Date range filters in Tractorscope

Using our built in date range filter example:
select * 
from payments
where [payments.created_at=daterange];
select * 
from payments
where [payments.created_at=daterange];
From the dashboard UI you can update the Date Range filter to generate new queries.
Tractorscope dashboard date range picker for filtering charts by time period
Date range picker on dashboard view
A custom date range is also available in the UI.
Tractorscope custom date range calendar picker for dashboard filters
Custom date range picker
When using the date range filter, the query would be modified to something like postgres example:
select *
from payments
where 
  payments.created_at >= '2022-09-13':: date 
	and 
  payments.created_at < ('2022-10-28':: date + interval '1 day'):: date
select *
from payments
where 
  payments.created_at >= '2022-09-13':: date 
	and 
  payments.created_at < ('2022-10-28':: date + interval '1 day'):: date

Related docs