Converting string to Date

I have the following string that I have been trying to convert to date. 'October 28, 2015, 11:33 AM ET' I have tried using the various tools within Alteryx and simple forumula tool. Basically all I want is either 28-10-2015 OR October 28, 2015.

thank you

Preparation

Accepted answers

Ned

There are 2 basic ways you can do it.

String processing. Use a Regular Expression or similar formula to extract the part you want.
Date Processing. Convert it into a standard Alteryx date and the format it back as a string. This could be done in a single formula tool, or multiple Date tools.

Attached is a module that demostrates both techniques.

FormatDate.yxmd

All comments

Ned

There are 2 basic ways you can do it.

String processing. Use a Regular Expression or similar formula to extract the part you want.
Date Processing. Convert it into a standard Alteryx date and the format it back as a string. This could be done in a single formula tool, or multiple Date tools.