Date Format not recognized

I’m working on parsing an XML and the tag pubDate (which appears to be a pretty standard XML tag) has a value of “Sun, 22 Jan 2023 00:00:00 -0400” However Make doesn’t seem to recognize this as a date value. Even wrapping it in a ParseDate or FormatDate tag doesn’t seem to work. Has anyone worked with a date in that format and been able to format it?

What I’m trying to do is take that date and create a filter, so I only get XML records with a pubdate equal to today (or greater than yesterday).

Thanks for any wisdom you can provide!

Hi @esowers

I think this is a date tokens format problem when you are parsing/formatting the date. You can give a try with the following example:


The output:

If you need additional support, please don’t hesitate to reach out.


1 Like