I have a text input tool with a two columns named start_date and end_date. The single row contains the values of both variables.
Now I want to pull data from an ODBC driver and in the SQL query, I want to use start_date and end_date values from the text input tool.
Any leads will be appreciated
Solved! Go to Solution.
To use the values of start_date and end_date from the text input tool in your SQL query, you can follow these steps:
This assumes that your SQL syntax requires date values to be enclosed in single quotes. Adjust the syntax based on your database.
This should allow you to use the start_date and end_date values from the text input tool in your SQL query. Let me know if you have any other questions or concerns.
@tahirlone you can change the Input Data tool to Dynamic Input tool by right clicking on it. Then you can select Modify SQL Query on this Dynamic Input and change variables as required.