Transform from text to date

Hi,lbendlin and parry2k ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.
After my testing, the M code provided by lbendlin works very well and it successfully converts the text to the corresponding date.

Has your problem been solved?

If you have found suitable solutions, please share them as it will help more users with similar problems.

Or you can mark the valid suggestions provided by other users as solutions.

Thank you very much for your understanding and support of Power BI.

I hope my suggestions  give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian