Power Query: Text string to date conversion

[igaca]

How does one convert -for example- "September 16, 2019 8:00 AM" into "9/16/2019" without decomposing the text string into relevant constituent parts (months, days of month, year) then re-constituting and formatting?

Thanks for your input!

IG

[gpoggi · Accepted solution]

Hi @igaca ,

Since the text has time inside, first conver it to DateTime and the extract the Date from this DateTime, for example if I you add this Custom Column:

Date.From(DateTime.From([Text Column]))

I'm extracting DateTime From text, and after that I'm extracting Date from this result in one line, this will return this:

Any question, just let me know.

Regards,

Gian Carlo Poggi

[igaca]

Thank you, sir.