I have psql queries that grab data within date ranges. So if I have a query (in it’s simplest form):
select * from table_name where date >= ‘2018-1-1’ and date < ‘2018-1-31’
How can I use the date selector in my dashboard to substitute those dates with a macro variable? Not sure what I am missing because I thought that I could use __dateFrom() and __dateTo() ?? If so, what is the proper syntax?
Thanks in advance…