I'm trying to only get rows of data with timestampz between a date entered into a date selection component and 2 days after that date. Right now, I am using moment(selectDate.value).format("YYYY-MM-DD") but SQL thinks this is an integer. Any help would be appreciated.
I was able to figure it out. You have to put single quotes around the double braces (like '{{}}'). However, there seems to be a bug in Retool's SQL IDE formatting that highlights text outside of single quotes when you put single quotes around double braces. Luckily, this doesn't affect functionality.