Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

SQL - User Prompt Input Date

JKrause
5 - Atom

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'

1 REPLY 1
ncrlelia
11 - Bolide

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

Labels