Forum Discussion
dates when importing data from a .csv file
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
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.
2 Replies
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!
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.
