SQL Date Comparison Syntax Error

App Building
1

I'm trying to pull the date in a date component into a query to only pull the data from beyond a certain date that the users enters but I'm getting the most bizarre error:

Trying here with a literal string in the YYYY-DD-MM format with double quotes around it is successful:

sql_error_3
sql_error_31950×1410 180 KB

Trying again with the startDateRange.value which has a literal value of "YYYY-DD-MM"

sql_error_2
sql_error_21738×1302 232 KB

I've tried CAST(), moment() and a couple other tricks. Even tried to SET @datevalue as a variable to be maybe easier to work through but it seems like I'm running into a brick wall with these odd quotes. The error references an earlier line but I can't suspect that as the culprit given a normal string works fine.

2

I see a single and a double quote near the date being called in the query within the error itself... but you didn't paste/screenshot the CASE portion of the query

Screen Shot 2022-10-17 at 9.29.12 AM
Screen Shot 2022-10-17 at 9.29.12 AM922×142 40.9 KB

3

Hey @JakeSankari, Were you able to figure out this error? Is it working fine calling select * from myTable where myCol >= {{ startDateRange.value }} ? If so, can you please paste your whole query here so I can try reproducing the error? Also, what version of Retool are you using?