SQL - User Prompt Input Date

Question

I have a SQL query embedded in an Alteryx workflow. The query requires the user to enter a date as DD-MMM-YY (ex. 15-AUG-22). A sample from the query is below. "INSERT_DATE" should be replaced by "15-AUG-22", in this case. How can I have the workflow request the user input the day of their choosing to run the query?

and trunc(a.create_dt) >= 'INSERT_DATE'

ncrlelia · Accepted Answer

Hi @JKrause,

You can use a Text Box or Date tools under the Interface Tools to capture user input and pass the value to your SQL query using a Dynamic Input tool.

Cheers,

Lelia