Forum Discussion
Solved
How to change YYYYMMDD into date format?
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
harshularora That's a number so you can't use Date.FromText, just use this:
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})
1 Reply
- Greg_Deckler
Community Champion
harshularora That's a number so you can't use Date.FromText, just use this:
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}})