Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

date time change

deepakpintya
7 - Meteor

Hi Team,

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

deepakpintya_0-1662395663412.png

 

3 REPLIES 3
BRRLL99
11 - Bolide

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
7 - Meteor

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

Could be a multi field formula useful?

DataNath
17 - Castor
17 - Castor

@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():

 

DataNath_0-1662414068538.png

Labels
Top Solution Authors