cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

How to enter multiple date as prompt in Analytic App

SOLVED
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!