We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Trouble with replacing string in dynamic input

crtakacs
8 - Asteroid

I'm trying to use the dynamic input tool with a prompt to have the user enter a date as the input. I wanted the default text in the prompt to show up as "MM/DD/YYYY" but I'm having trouble. Below is my layout - would someone be able to assist? 

 

crtakacs_0-1619034056196.png

crtakacs_4-1619034220686.png

 

crtakacs_5-1619034232803.png

crtakacs_6-1619034246599.png

 

crtakacs_8-1619034277653.png

crtakacs_10-1619034358768.png

 

 

 

 

 

 

1 REPLY 1
apathetichell
20 - Arcturus

why wouldn't you use a date selector instead of a text input box?

 

you can also attach an error tool with something like

regex_match([field],"\d{2}/\d{2}\/d{4}") as the expression to evaluation...

 

Also - I believe your dynamic input SQL criteria should reflect the name of your field (ie [Enter Business Date]) since that will contain the updated MM/DD/YYYY

Labels
Top Solution Authors