Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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
Top Solution Authors