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
Solved! Go to Solution.
Right now I get NULL value when I use convert tool then split text to columns
hI,
If you want to transform the column to date format you can use the date time tool.
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.
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