dates when importing data from a .csv file

[MarcUrdang]

Hi

When I import data from a .csv file the dates get all muddled ... for example: 2019/12/04 (yyyy/mm/dd) becomes 2004/12/19 .. is there some formula I can create in a column to rectify this?

If I import from a .xlsx file there are no problems.

thanks

Marc

[v-juanli-msft · Accepted solution]

Hi @MarcUrdang 

Add a column below:

Text.Combine({"20" & Text.End([Date], 2), Text.BetweenDelimiters([Date], "/", "/"), Text.End(Text.Start([Date], 4), 2)}, "/")

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@MarcUrdang check this post and hope it helps.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!