Replace SQL string in all Input Data instances

[asp_ty]

Hi,

I'm currently using Alteryx to automatically run 2 queries from Teradata and output them to Excel. I do this daily so every day I would go into the SQL code for each Input Data instance and update the date in the SQL code to the current date. is there a faster way of doing this manually? thanks. 

[JeremyG]

You can also try using a Dynamic Input and enter your date in a text input. See attached (click the Edit button on the top left of the Dynamic Input and connect to your DB. The Select tool is optional, but you can change the date data type to a string if you need to. Alteryx's default date is yyyy-mm-dd. I didn't see any problems with the app, but maybe the Dynamic Input will work.

[asp_ty]

Hey Nick, I actually went back and redid my work flow using the same process that you provided and it worked! I'm not sure why it didn't work the first time around, but it's working perfectly now. thanks!