Dynamic Input isnt Replacing text in SQL

[ctpiccone]

I am trying to make my workflow more dynamic by asking the user certain dates when the workflow starts, then updating the SQL query accordingly. Attached is the configurations for the dynamic input and the text input. 

Here is the SQL code I want to change:

...And (IRDB.EARNED_INCOME_IFM.STARTING_DATE) = Date '[Prior Year End]' And (IRDB.EARNED_INCOME_IFM.ENDING_DATE) = Date '[Reporting Date]' Group By... 

However, each time I try to run it, I get the error seen in the photos. What am i doing wrong, and why wont it replace the text I want it to? I have tried the update where clause option too, but no change there either, I have also tried to make the import be a date instead of a string, but no progress.

[fmvizcaino]

Hi @ctpiccone ,

Since your dates needs to be between quotes, maybe your problem is inside your action tool configuration.

You need to replace only the date and leave the quotes there.

Best,

Fernando Vizcaino

[ctpiccone · Accepted solution]

I think I was able to figure it out! I had to take the quotes away from the dates in the text input, and in the replace box I had to be sure not to include quotes there either. Although, I did have to have quotes around the string to replace in the SQL code. Thanks for the help!