Inserting Date Parameter into SQL to pull data

Hello,

I have a current process where I converted a Workflow to a Workflow App and am using a text box and action tool to prompt the user to enter a date that will feed into the SQL condition and pull data into my workflow. My question is, if they wanted to use a date range, how can I accomplish this with the stated model? Do I have to use another tool other than Text Box/Action tool?

Datasets

Accepted answers

tristank

Hi Recoil hope you are well.

Would there be an issue with feeding two action tools into the tool where you are modifying your SQL? I would maybe just put two Date interface tools in and specify which one is for the start / end dates within the app itself. From there it's just a WHERE with two conditions.

app inputs.png

All comments

tristank

Hi Recoil hope you are well.

app inputs.png

RCern

Thank you! I didn't know that was possible!!!

tristank

Of course and thanks for accepting the solution! Have a great weekend

Taidaisher

Is there a way to achieve this by using a drop down tool, with pre-selected quarters, to pass the start/end date into the SQL statement?

I'm currently using two Date/Action tools, one to set the start date and the other to set the end date. I would like to be able to set the dates from the drop down selection.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703