Converting from Text to Date

Question

Hi all,&nbsp;I am trying to create a date table based on this date format:&nbsp;&nbsp;Tue Mar 27 10:33:09 CST 2018. This is downloaded from a CISCO platform.&nbsp;I tried creating a new column and then adding a MID - CONCATENATE formula. The date is shown as text and looks like this :&nbsp;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.&nbsp;Also, I tried to do something similar to extact the hour but no luck.&nbsp;Any help will be highly apreciated.

roboto · Accepted Answer

I got the solution, I was able to break the date in the query section and then extract the hour.&nbsp;It would had been good to notice it before posting this question, though lol.

Forum Discussion

Converting from Text to Date

1 Reply

Related content

Convert text to number

Convert HTML to Text

Snowflake connector: "We cannot convert the value null to type Text"

Converting from Text to Date

Convert text to date