Changing Date Format Coming From Data

[mlail]

Hello,

I have an example report that has been trimmed down to what i am looking at. The Planned date is formatted as the date and time i would like to know how to split the column into two one for the date and one for the time. Right now it is "Nov 4 00:32:" I would like it to be "11/4/2018" and "00:32" 

I've tried using the Date Time parsing tool and the text to columns tool as well. With no luck

Looking for some help.

I have attached the example report. 

Thanks!

[mlail]

Yes the dates in excel are that way but when i pull them into alteryx it's not showing. Is it due to the file format? That's the only difference i see between the two photos. If that's it then that is an easy fix!