date time change
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I wanted to change the data columns(String) to date time (month,date,year)
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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]",''))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to use seperate datetime tool for each, i need in one formula.
Could be a multi field formula useful?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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():