Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago
Solved

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?   ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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.