String to Date & Time fails to execute

[sroberts]

Hi all,

I’m trying to convert a string date into a date format, but running into issues while executing. Getting the error failed to parse date in row.

Example data is below,

15 Sep 2022 9:12:08 AM
15 Sep 2022 9:14:16 AM
15 Sep 2022 9:10:15 AM
21 Sep 2022 4:38:14 PM
15 Sep 2022 9:06:17 AM
15 Sep 2022 9:08:10 AM
15 Sep 2022 9:12:08 AM
14 Sep 2022 3:46:10 PM
14 Sep 2022 3:46:09 PM
14 Sep 2022 3:46:11 PM
14 Sep 2022 3:46:11 PM
14 Sep 2022 3:46:10 PM
14 Sep 2022 3:46:10 PM
21 Sep 2022 4:38:15 PM
25 Sep 2022 8:30:19 PM
17 Sep 2022 8:30:20 PM

[elsamuel]

Why are you using that date format to configure the node? It’s clear from inspection that it doesn’t match the data. Your data has a 3-letter date, no period separators, and no fractions of seconds. Yet, the format you’re specifying has a 2-number date, period separators, and fractions of seconds.

The format should look something like this: dd MMM yyyy h:mm:ss a

The node description explains all the pieces.