convert string "Wed Mar 02nd 2016 00:00:00" to a valid date

Hi all

I have a datasource where the datestring is in this format:

Tue Mar 01st 2016 00:00:00

Wed Mar 02nd 2016 00:00:00

Thu Mar 03rd 2016 00:00:00

Fri Mar 04th 2016 00:00:00

...

Could you please give me a tip how to convert it in a valid date format ?

Many thanks in advance

Steffen

Input

Preparation

Accepted answers

I have attached a workflow built in Alteryx 11.0 which details converting this to an Alteryx date format.

Hopefully this get's you along the right path, but I am sure others can contribute utilizing Alteryx's other more direct date time formulas options.

best,

Jordan barker

Solutions consultant

I have attached a workflow built in Alteryx 11.0 which details converting this to an Alteryx date format.

Hopefully this get's you along the right path, but I am sure others can contribute utilizing Alteryx's other more direct date time formulas options.

best,

Jordan barker

Solutions consultant

This is solved but I like playing with dates. Wanted to post my solution.

Less tools the better, nice work @Kanderson.

Best,

Jordan Barker

Solutions Consultant