Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Transform from text to date

Hello everyone I'm working on transforming some data that comes from a file obtained through Google Sheets. The problem I'm facing is that the date field appears as text and doesn't allow me to conv...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago

Thanks, but I think it didn't work for me... I share screenshot.

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Try with culture

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCilNVTAwVghOLdBRMDKwMjW1MjZWcPcNAXKMTJRiYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each DateTimeZone.FromText(Text.Replace([Column1],"GMT ","+00 "),[Format="ddd dd MMM, HH:mm:ss zz yyyy", Culture="en-US"]),type datetimezone)
in
    #"Added Custom"