Limiting Input Ranges


#1

Hey guys,

I’m curious if anyone knows a way to limit the field filters range.

Currently I have something like

select
purchasedate,
product,
quantity

from sales

where purchasedate > {{start}} and purchasedate < {{end}}

but I’m trying to limit the search for the purchase date to 3 months.

Any suggestions?


#2

use variable
where {{purchasedate}}


#3

that will only allow the exact purchasedate, and not limit the range of the {{start}} and {{end}}.