Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to enter multiple date as prompt in Analytic App

khu
8 - 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 

1 REPLY 1
danrh
13 - Pulsar

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