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