Here is my solution.
The datetime Tool did not work in my case. I had to replace abbreviated month name by full month name to parse the date.
That's great to have challenges for Alteryx Cloud :)
Come late
Here is my solution using Regex:
I have absolutely no idea why but the DateTimeParse function didn't work for me, neither did the DateTime tool.
My 2nd experience with Cloud! It's like learning Alteryx all over again. So fun!