Date Range Filter

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.
Date range picker on dashboard view
Date range picker on dashboard view
A custom date range is also available in the UI.
Custom date range picker
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