Dynamic input - Update where 'date' not detected

[noobteryx]

Hi All,

I'm pulling some data from a work server (inventory holding by SKU by week) but only want it pull the data for a certain set of SKUs and past a certain date. I have therefore put a dynamic tool on it so i can specify the date and SKUs I want. I set my dynamic input with a SKU listing and great all worked fine. I then brought in a simple date via text input then an append (please dont cringe as im sure this wasnt the most effective method!) but so far so good for 3 of my queries!

However for one of my queries it isnt detecting the WHERE date >=X and im guessing its the string I've been given but dont know how to correct for the dynamic input tool to detect it.

Full flow:

The full SQL string of the query that isnt working:

How the dynamic tool looks when i want to find the date clause:

[Qiu]

@noobteryx 
Maybe the thread below can help you?

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-SQL-Update-multiple-clau...

[noobteryx]

@Qiu 

That looks exactly my issue, how do i adjust my query then to use IN (instead of >=) but still give me the option of > rather than a single date?

[noobteryx]

OK i managed to solve it by just trial and error....i needed to drop the "DATE" string before the date and then the tool picked it up!