Multifield Formula for changing data from Text to Date Format

[aysha6029]

Hi,

I have a file which consists of Date Format data as below. I want to read the data using Input tool and load it to Greenplum Database. I tried Select and Multi field Formula Tool for Date conversion. Nothing is working out for me. i know i am missing some thing. i request you to help me to solve this issue

S.No   Name     Date

1        Harbour  04/23/2015

2        seaman  03/22/2015

3        Hannah  12/22/2015

Regards

Aysha

[pcatterson · Accepted solution]

There is a DateTime Tool in the Parse Tab.  You select the type of formatting your date string is in and it converts it to alteryx's default date format.

[jdunkerley79 · Accepted solution]

If you only have a single column to parse. I suggest a DateTime tool. It can parse the format you have without a problem.

If you have multiple fields to parse then as @pcatterson mentioned use a MultiFieldFormula tool with the DateTImeParse function.

Simple sample attached with both methods

[aysha6029 · Accepted solution]

Thank You. It is working now