Forum Discussion

dkgcb's avatar
dkgcb
Frequent Visitor
2 years ago
Solved

How to convert text into date, time and zone

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.

4 Replies

    • dkgcb's avatar
      dkgcb
      Frequent Visitor

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

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        Ideally your source dates should be in ISO8601 format.