date time change

[deepakpintya]

Hi Team,

I wanted to change the data columns(String) to date time (month,date,year)

[BRRLL99]

1. First use Date time tool from Parse and convert the Date field to a proper Date format

2. Drag formula tool and write the query as DateTimeFormat([Datefield],"%d-%b-%y")

3. Now again drag the formula tool and write the query as (Regex_Replace([Datefield],"[^a-zA-Z0-9]",''))

[deepakpintya]

I need to use seperate datetime tool for each, i need in one formula.

Could be a multi field formula useful?

[DataNath]

@deepakpintya is this what you're looking for? I had to use the Select tool to force the dates into a String data type before showing the Multi-Field Formula. Alteryx ought to auto-detect your dates as the right data type, is it not? If it is then you don't need the DateTimeParse() function, you can just go straight to changing the format with DateTimeFormat():