Text 05112022 to date in Power Query

[SueKi]

I'm pulling in data from a bunch of files. The file title has a 8 digit date included, which I can seperate out with Power Query in the clean up. I can figure out how to convert it to a date in PW, though, can I do it there, or do I have to do it after import? Thanks!

 

[Error 1004]

Hi, chek this example.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjA1NDQyMDJSitWJVjIGsiGcWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Text.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.FromText([Column1], [Format="ddMMyyyy"]))
in
    #"Added Custom"

 

[SueKi]

Hi, chek this example.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjA1NDQyMDJSitWJVjIGsiGcWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Text.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.FromText([Column1], [Format="ddMMyyyy"]))
in
    #"Added Custom"

Nice, thank you!