String to DateTime Format

[dkma]

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

[messi007 · Accepted solution]

@dkma,

Please check this link : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Auto-Convert-Most-Any-Date-Macro/td-p/... 

Regards,

[atcodedog05 · Accepted solution]

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:

Hope this helps : )

[messi007]

@dkma,

Please see below :

Attached the workflow,

Regards,