Forum Discussion

nhoff's avatar
nhoff
Advocate I
9 years ago
Solved

Change to time/date error in query

I am trying to convert a column from text to date. The format of the data is:

 

Tue, 11 Oct 2016 15:29:08 +0200

 

When I convert, I get the following error:


DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Details:
Tue, 11 Oct 2016 15:29:08 +0200

 

Any sugestions for how to fix this?

Need Help
  • nhoff's avatar
    nhoff
    9 years ago

    I have used this piece of code, that satisfied the issue

     

    = Table.AddColumn(#"Renamed Columns1", "Created3", each Text.Start(Text.End([created],Text.Length([created])-5),Text.Length([created])-10))

1 Reply

  • nhoff's avatar
    nhoff
    Advocate I
    9 years ago

    I have used this piece of code, that satisfied the issue

     

    = Table.AddColumn(#"Renamed Columns1", "Created3", each Text.Start(Text.End([created],Text.Length([created])-5),Text.Length([created])-10))