Date Range Input from User

Question

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 Answer

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 Answer

@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 Answer

@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.