Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

String to DateTime Format

dkma
8 - Asteroid

Hi all,

 

The are are several DateTime strings in Several format, Is there any way to change any type of DateTime String to DateTimeformat like 

 

 

Sep 2, 2021 23:45
Sep 1, 2021 7:27
Sep 1, 2021 23:57
Sep 2, 2021 23:57
Sep 1, 2021 23:58
Sep 2, 2021 23:54
Sep 1, 2021 23:45
Sep 2, 2021 23:45
Sep 1, 2021 23:45
Sep 2, 2021 23:48
Sep 1, 2021 8:33
Sep 2, 2021 8:34
Sep 1, 2021 23:45
Sep 1, 2021 23:54
Sep 2, 2021 23:56
Sep 1, 2021 23:58
Sep 1, 2021 23:57

Sep 2, 2021 7:33am
Sep 2, 2021 7:36am
Sep 2, 2021 7:32am
Sep 2, 2021 7:30am
Sep 3, 2021 7:07am
Sep 2, 2021 7:38am
Sep 2, 2021 11:27am
Sep 2, 2021 5:33am
Sep 3, 2021 7:08am
Sep 1, 2021 11:01am
Sep 2, 2021 6:37am
Sep 3, 2021 6:55am
Sep 2, 2021 7:32am
Sep 3, 2021 7:08am

Sep 2, 2021 7:33am
Sep 2, 2021 7:36am
Sep 2, 2021 7:32am
Sep 2, 2021 7:30am
Sep 3, 2021 7:07am
Sep 2, 2021 7:38am
Sep 2, 2021 11:27am
Sep 2, 2021 5:33am
Sep 3, 2021 7:08am
Sep 1, 2021 11:01am
Sep 2, 2021 6:37am
Sep 3, 2021 6:55am
18.5.21 7:41
19.5.21 7:35
20.5.21 7:28
21.5.21 7:31
22.5.21 7:26
25.5.21 7:27
26.5.21 7:28
27.5.21 7:27
28.5.21 7:29
29.5.21 7:23
31.5.21 7:26
25.5.21 0:00
25.5.21 23:31
26.5.21 23:46
27.5.21 23:47
2.5.21 23:42
3.5.21 23:38
4.5.21 23:45
5.5.21 23:43
7.5.21 0:00
9.5.21 23:57
10.5.21 23:33
11.5.21 23:41
13.5.21 23:36
14.5.21 22:50
17.5.21 23:53
19.5.21 0:07
20.5.21 23:53
21.5.21 23:59
25.5.21 23:56
26.5.21 23:57
28.5.21 23:52
3.5.21 23:49
4.5.21 23:51
5.5.21 22:38
6.5.21 23:45
7.5.21 23:30
9.5.21 23:44
10.5.21 23:51
13.5.21 23:39
14.5.21 22:38
16.5.21 23:42
17.5.21 23:43
19.5.21 23:34
20.5.21 23:34
24.5.21 23:44
26.5.21 23:49
28.5.21 23:48
10.5.21 7:30
12.5.21 7:30
14.5.21 7:31
10-Feb-21 06:00 AM
10-Feb-21 11:00 AM
11-Feb-21 06:00 AM
11-Feb-21 11:07 AM
12-Feb-21 06:00 AM
12-Feb-21 11:02 AM
15-Feb-21 09:00 AM
15-Feb-21 01:43 PM
16-Feb-21 06:00 AM
16-Feb-21 10:41 AM
08-Feb-21 06:00 AM
08-Feb-21 11:45 AM
09-Feb-21 06:00 AM
09-Feb-21 11:01 AM

10-Feb-21 06:00 AM

 

 

 

Thanks and regards,

Nikil

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora
atcodedog05
22 - Nova
22 - Nova

Hi @dkma 

 

Here is how you can do it.

 

Formula:

IF Contains([Date], ",")
THEN DateTimeParse([Date],"%b %d, %Y %I:%M %p")
ELSEIF Contains([Date], ".")
THEN DateTimeParse([Date],"%d.%m.%y %H:%M")
ELSEIF Contains([Date], "-")
Then DateTimeParse([Date],"%d-%b-%y %I:%M %p")
ELSE Null() ENDIF

Workflow:

atcodedog05_0-1630663629183.png

 

Hope this helps : )

 

messi007
15 - Aurora
15 - Aurora

@dkma,

 

Please see below :

 

messi007_0-1630664725826.png

 

Attached the workflow,

Regards,

Labels