cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | Looking to expand your Alteryx skillset?! Check out the latest set of interactive lessons in Alteryx Academy: Creating Analytic Apps
SOLVED

How to enter multiple date as prompt in Analytic App

Highlighted
Asteroid

Hi, Community,

 

I want to build an analytic app which will require user to enter dates,

The tricky part is user may enter 1 date, or multiple dates, 

I know usually one date in interface tool just allow you to select one date,

Just wonder how to allow user to select multiple dates,

The goal is to concatenate these dates as a string and use it to update a SQL query.

 

Thanks 

Quasar

I'd suggest using a Text Box and prompting the user to comma separate the dates.  At this point, you should be able to parse them out so they are in the correct format, then re-concatenate them back together to update your query.  Something like the attached.

 

Good luck!

Labels