parseDate refusing to parse an RSS date

How To
1

I want to turn a date from an RSS feed into a simpler format, but parseDate is throwing errors.

The RSS standard formats dates like this:
“Fri, 21 Mar 2025 06:00:00 +0100”

I need this in the form of “2025-03-21”.

I tried parsing the full string:
parseDate(54.RSSDate; “EEE, dd MMM yyyy HH:mm:ss Z”)

But i get the error: “Failed to map ‘values.2’: Function ‘formatDate’ finished with error! ‘Fri, 21 Mar 2025 06:00:00 +0100’ is not a valid date.”

I then tried to use substring to remove the weekday and the timezome. So just using the string “21 Mar 2025” with the format string “dd MMM yyyy”. But I still get the same error. “21 Mar 2025 is not a valid date”.

Any ideas would be highly apreciated.

Thanks,
Nico

2

Found the problem myself: I had used the wrong tokens in the format string. The correct string is “ddd, DD MMM YYYY HH:mm:ss ZZ”

I had used the tokens as they work in IBM systems - i thought this was a universal default.

But Make.com uses these tokens.

2 Likes
3

Welcome to the Make community!

Yes, Make uses JavaScript tokens. For more information, see “Date Format” links below:

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.