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
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.