Use Text Box and Action tool to change date to extract data using SQL server

[sureslala]

Hello 
I have created a workflow that connects to my works database using Microsoft SQL Server OleDB. 

It retrieves data for a particular file name and then multiple different columns as shown below. Currently I have to change the date 22 times (or copy and paste) to run each time. I believe by using a 'Text Box' and 'Action Tool', I can enter a date in the 'Text Box' and it will update all the 'Dates' (highlighted yellow) in my SQL Editor so that my workflow runs for the date specified. 

Here's my workflow

I need help please configurating the Text box and or Action box as I can't get this to run with different dates..

Thanks

Sures

[sureslala]

Hi Binu
Cracked it! :) thank you. I could see the Analytical Action tool was changing the data however couldn't see/extract the data. I researched and saw that on 'Interface Designer'  I had to select 'Browse. I then could see the changed data and export it to csv file.

Thank you very much for your help!

Sures

[sureslala · Accepted solution]

Hi Binu

Thanks managed to crack it, could see my Analytic tool was generating the data however I couldn't extract it. After doing some research, noticed on 'Design Interface' i had to select 'Browse' I could then see my updated data and export it!

Thanks again for your assistance!

Sures