Date Range Input from User

[dineshbabu2811]

Hi,

I am trying to get start date and end date from business user using Date tool and converting that date in YYYMMDD format to pass the dates into SQL query string.

used Between function in SQL query and replacing the specific value using start and end date.

But I tried in multiple ways, its not working as expected. Kindly suggest some solution.

 

[alexnajm · Accepted solution]

This looks correct, so what exactly is not working? Is it that the formatted date values aren't updating the SQL query in the Dynamic Input tool you should have after the Formula?

[DanielG · Accepted solution]

@dineshbabu2811 -- make sure the fields you are creating in the formula are not Date Types.  If they are strings, they will be able to handle those formulas as Alteryx Dates require the YYYY-MM-DD structure.

Hope this helps.  😊

[DanielG · Accepted solution]

@dineshbabu2811 - it would help too if you could share your workflow or the portion with issue to help really hone in on the issue and troubleshoot exactly in the workflow that contains the issue.  Not required, but just a suggestion to help get to an answer quicker.  

[dineshbabu2811]

@alexnajm  @DanielG  Yeah it worked as expected, Under action button replace string value was not matching. Now its running the SQL query using dynamic input tool.

Thanks guys!