How to change YYYYMMDD into date format?

[harshularora]

Want the orderdatekey column in format YYYYMMDD using Date.FromText() function can someone please help, ive tried all the steps it still gives me error

[Greg_Deckler · Accepted solution]

@harshularora That's a number so you can't use Date.FromText, just use this:

   #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})