I am trying to create a date table based on this date format: Tue Mar 27 10:33:09 CST 2018. This is downloaded from a CISCO platform.
I tried creating a new column and then adding a MID - CONCATENATE formula. The date is shown as text and looks like this : 01 Mar 2018 but when I tried to format it to an actual date, it gives me this error: Cannot convert value '' of type Text to type Date.
Also, I tried to do something similar to extact the hour but no luck.