How to convert text into date, time and zone

[dkgcb]

Here is the data in the text column that I imported from a log file (Apache web logs). Locale is USA, English. I changed the project settings > options > reginal settings to use English (USA)

Jan 1 2023 11:37:23.86 CST

I'm getting error try to change the data type to Date/Time/Zone:  DataFormat.Error: We couldn't parse the input provided as a DateTimeZone value

The only way I can think of is to split into separate columns, change the data, the combine them using '/' into a new column. Is there an easier way to have PowerBi recognize Jan 1 2023 11:37:23.86 CST as a date? It seems commonly used date format.

[lbendlin · Accepted solution]

[dkgcb]

Thank you! that is exactly what I was looking for.

[lbendlin]

Ideally your source dates should be in ISO8601 format.

[dkgcb]

100% agree.