Forum Discussion
Date Format Error
Hi, Hope someone can help me. I have looked through many forums but didn't come across this one. My regional settings is English (United Kingdom) and Data load type detection is set to below....
An ez solution I found is to split the column by the separator "/", now u have dd mm yyyy, after that u add all of them into a new column with this "Text.PadStart(Text.From([Day]), 2, "0") & "/" & Text.PadStart(Text.From([Month]), 2, "0") & "/" & Text.From([Year])", with this u can change it into date.