This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
The Alteryx date type is always in the configuration YYYY-MM-DD. So if you are wanting to get it into a Date type field to do calculations, filtering, etc. based on it being a Date type, it will need to be converted to that using DateTimeParse (with "%d.%m.%Y" specifiers).
If you want to maintain your original format for presentation purposes, you could just add a field parsed into a Date type, use that for any calcs or filters, and then unselect it further down the workflow.