I don't know if there's any advantage with the following except for it being easy to change whether the source data is in US or UK date format:by changing en-US to en-UKCode:let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], ChangedTypewithLocale = Table.TransformColumnTypes(Table.TransformColumns(Source, {{"Text", each Text.Insert(Text.Insert(_,4,"/"),2,"/"), type text}}), {{"Text", type date}}, "en-US") in ChangedTypewithLocale
2021-02-21_183057.png




Reply With Quote
Bookmarks