Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Possible help with Date time tool

Bbadef
8 - Asteroid

I am working on an Excel document using Alteryx. There is a field in document called same_day_arrival.I am using the Custom in the Datetime tool to convert it to the format I want. It is able to convert the time I needed correctly, but there is a problem I have. Every time I save and then reopen the workflow, the format will disappear and showed  "No Suitable Input Fields". Available." I had to run the workflow once and then re-edit the tool after the error message poped up.Is there any way I can fix that?Here is what same_day_arrival  looks like.

Same_day_arrival

3:30

4:40

My expected Output

3:30:00

4:30:00

Thank you for your help and have a good one

 

10 REPLIES 10
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Hey @Bbadef if this solved the issue, be sure to mark the question as solved so that others experiencing the same thing can benefit from your post.

Labels
Top Solution Authors