community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Posting date conversion

Atom

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

 

 

Atom

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

Alteryx Certified Partner

hI, 

 

 

 


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

 

clipboard_image_0.png

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.

Atom

Thank you

Labels