Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

How to convert or remove a part of this date format : Sun Apr 01 14:33:41 +0000 2018

NoraMK
7 - Meteor

 

- How can I remove a part of the field like in this example : Sun Apr 01 14:33:41 +0000 2018 , I need to delete this part: 14:33:41 +0000

- When I delete the time part of this example : Sun Apr 01 14:33:41 +0000 2018, How can I convert the rest of the format to the date?

- In case I want to use hours and date which is : Sun Apr 01 14:33:41 +0000 2018 in my analysis, how to convert it to date- time format?

2 REPLIES 2
ivoller
12 - Quasar

Here's one approach

 

2018-07-10_16-04-59.png

AdamR_AYX
Alteryx Alumni (Retired)

Here's another :)

 

DatetimeFormatting.png

Adam Riley
https://www.linkedin.com/in/adriley/
Labels