Posting date conversion

[Kar3]

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.

Thanks

[Kar3]

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

[geraldo]

hI, 

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

[JosephSerpis]

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.

[CharlieS · Accepted solution]

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.

[Kar3]

Thank you