Forum Discussion

Easley08's avatar
Easley08
Icon for Helper I rankHelper I
2 years ago
Solved

Text to Date

Hi,   is this possible to make this text to date  thanks
  • olgad's avatar
    2 years ago

    Hi, it is possible to get a date out of Yes (Apr 23) in a format 01/04/2023, which date would you like to have in case of Yes (Apr) ?? 

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WikwtVtBwLCjSVIrVQfAUjIyBArEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","(","",Replacer.ReplaceText,{"Date"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",")","",Replacer.ReplaceText,{"Date"}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Replaced Value1", "Date", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Date.1", "Date.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type text}, {"Date.2", type date}})
    in
    #"Changed Type1"