Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

DateTime Tranformation Problem

Cpach
5 - Atom
‎05-20-2021 05:45 AM

Hello Alteryx Community!  Does anyone have a suggestion on how I can transform this UTC date/time from this...

 

CreatedDate
2020-02-01T00:06:41.857182
2020-02-01T00:22:51.098292
2020-02-01T01:33:30.925012
2020-02-01T01:37:33.905916

 

Into this type of format...

DateTime Added
11/02/2020 10:52:27 AM
11/02/2020 10:52:27 AM
11/02/2020 10:52:50 AM
11/02/2020 10:52:50 AM
11/03/2020 5:43:48 PM

 

Any help would be appreciated.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor
‎05-20-2021 05:59 AM

 Hi @Cpach 

 

Take a look at the attached. I broke it into two new fields to demonstrate what is happening, but you could consolidate the formulas into one if you want.

 

  1. Parse the date into alteryx datetime format
  2. Format the date how you require

More info on date time functions can be found here

 

Luke_C_0-1621515489865.png

 

New Workflow1.yxmd
Reply
Cpach
5 - Atom
‎05-20-2021 07:24 AM

Thank you so much for the help! 🙂

Reply
Luke_C
17 - Castor
17 - Castor
‎05-20-2021 07:27 AM

Not a problem, I should note that I made some assumptions on the order of month/day, but that is easy enough to tweak.

 

If this works please be sure to mark accepted, date time questions are pretty common and it will help people in the future find an answer.

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All