Date Format not recognized

Questions & Answers
1

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!

2

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:

image

The output:
image

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

//VLAD

1 Like