Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

MMDD and YY columns

Hello Everyone,

 

I have 2 columns below, how can I convert them to a proper date format like 1/4/2021? Thanks in advance.

 

 

DA

5 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous ,

    Go to Power Query - Split the column by the 2 right characters, join the three columns with "/" and change to date.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

      • Nathaniel_C's avatar
        Nathaniel_C
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Hi Anonymous ,


        If this solves your issues, please mark it as the solution, so that others can find it easily. 
        Nathaniel