Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

String to Date column

Hi, 

I have a text output like this 

 

2024-02-15T23_34_17+00_00.pdf

 

What I want is a new column that extracts the date only part of the text formatted as dd-mm-yyyy

 

Any idea how to do this please?

Need Help

1 Reply

  • NaveenGandhi's avatar
    NaveenGandhi
    Memorable Member
    2 years ago

    Hi M_SBS_6 

    Check the attached Power Query solution.

    Let me know if you have any questions.

    If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

    Follow me on LinkedIn!!!


    LinkedIn