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.
Solved! Go to Solution.
Thank you so much for the help! 🙂
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.