Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Posting date conversion


Hi ..I am new to Alteryx- so sorry for basic question .Sorry if this has already been discussed in the blogs


How to convert a date field which is in V string to Date so I can split to get the Month/Date/YYYY in 3 separate columns.






Right now I get NULL value when I use convert tool then split text to columns

Alteryx Certified Partner





If you want to transform the column to date format you can use the date time tool.



Alteryx Certified Partner
Alteryx Certified Partner

Hi @Kar3 if your field is a string and you want to split into 3 columns you can just use text to column with a delimiter and not have to convert the date depending on the original format of the date. Have attached a workflow.

Alteryx Certified Partner
Alteryx Certified Partner

If your input is a string formatted as "MM/DD/YYYY", then I've attached a workflow that shows two ways to approach this. 


1. Keep it as a string and split to columns on the "/" character.

2. Format the value into the standard date format, and parse out the pieces you want from there.


Thank you