In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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