Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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