Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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


There are 2 basic ways you can do it.


  1. String processing.  Use a Regular Expression or similar formula to extract the part you want.
  2. 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. 

i would like to To Add on more to Ned's Solution, you can use the formula tool to parse your date and format your date.


@ned, i used your workflow and added Formule portion.


Alteryx has Many solution for one problem :)


@Pvara, you can refer the below Link for datetime pasring


Thank you the Regex worked however I did get a error when running the Convert Field.

Alteryx Partner

I have a String column in format and I want to convert that to date datatype. Result: (Date)

Alteryx Alumni (Retired)


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.


Thx... that was helpful.


I needed to treat a string formatted like 1995-12 as December of 1995.


In the Forumla tool I used:

DateTimeParse([MyDateField], "%YYYY-%mm")


and just like that, it worked.


@RodL  can i just check, are you saying that the field currently set as string has to be changed to a date/time field before you attempt the date/time parse?