Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date and time from user input in app

Ekmi9
8 - Asteroid

hello everyone ,

 

How I can ask user to select date and time and store into one filed. 

 

Appreciate your help !

 

Thanks in advance !

2 REPLIES 2
VijayAnaparthi
8 - Asteroid

I don't think user can directly select time. Because we have only Date tool in interface tools.

 

Step 1 - Create Text input tool with two columns and column names are Date and Time and it contains only 1 row which is in Date column give 1/1/2023 and In Time column give 12:00:00 .

 

Step 2 - Use Date Tool from interface tools and connect to Text input tool. In Action select update value. You can select that 1/1/2023 in replace string filed in action too.

 

Step 3 - Same way like step 2 connect Text Box tool from interface tools to Text input tool and now in action tool update 12:00:00 .

 

Step 4 - Connect formula tool after Text input tool to combine both Date and Time column values to single column.

 

I know here step 3 is not user friendly but we don't have any Time tools. Because of that user needs to enter Time in textbox.

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @Ekmi9 ,

 

There is Date tool which shows a calendar to select, but there is no "Date / Time" tool.

So if you want to "ask" the user, you need to ask explicitly in the interface.

 

Here is a sample App.

 

APP

Yoshiro_Fujimori_0-1683272623554.png

 

Text Input configuration

Yoshiro_Fujimori_1-1683272665593.png

 

Error Message tool configuration

Yoshiro_Fujimori_2-1683272696189.png

 

Interface

Yoshiro_Fujimori_3-1683272791009.png

 

Error Message

Yoshiro_Fujimori_4-1683272830250.png

 

 

Labels
Top Solution Authors