I am trying to use variables set in a date-picker control, to filter data in a SQL query. I have two variables, $StartDate and $EndDate. The values appear as expected in the Klip, but my SQL query is not returning any data. I'm assuming it's something in the way the $StartDate and $EndDate variables are passed to SQL???
Date picker:
Klip showing variable values:
SQL Query showing how I am referencing the variables:
SELECT <column1>, <column2> FROM <table>
WHERE SalesDate >= {props.StartDate}
AND SalesDate <= {props.EndDate}
Additionally, in my data source query, I get an error when on the AND.... I