Converting from Text to Date

[ROBOTO]

Hi all,

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.

Any help will be highly apreciated.

[ROBOTO · Accepted solution]

I got the solution, I was able to break the date in the query section and then extract the hour.

It would had been good to notice it before posting this question, though lol.