Helping converting a date in format "Mon, 03 Jan 2022 21:09:36 GMT"

Ask a question
1

Hi! I have looked through all of the documentation I can find, and still can’t figure out why Parabola isn’t picking up my date for formatting.

The “Pull from Twilio” pulls in messages with date stamps in the format “Mon, 03 Jan 2022 21:09:36 GMT”

I have a Format Dates step to convert this. It will not auto-detect, so I tried using the accepted formats as “ddd, DD MMM YYYY HH:mm:ss ZZ”. I keep getting the same error unfortunately - “There are dates in an unknown format, try setting the old format to convert them”

Any help or ideas much appreciated!

Full window here:

image
image610×760 45 KB

2

Have you tried updating the starting format with a timezone of zz or just z? I think capital ZZ is actually for -0700, -0600, etc., and not GMT, PST, etc.

Alternatively, you could also find and replace the GMT with a blank result and run the Format Dates Step on the new date stamps, without the timezone.

1 Like