DateTime Tranformation Problem

[Cpach]

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.

[Luke_C]

 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

[Cpach]

Thank you so much for the help! 🙂

[Luke_C · Accepted solution]

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.