Limiting Input Ranges

Get Help
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}}.