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