String to Date column

[M_SBS_6]

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?

[NaveenGandhi · Accepted solution]

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