I'm writing a little admin system for updating our site news scroller. I would like the news scroller to be fed from our RSS xml file.
Dates in RSS feeds, as I understand it, need to be formatted to RFC822. In short, they need to look like this:
The trouble is, that looks pretty rubbish squeezed into a news scroller. I want the dates in that to look like this:Fri, 13 Jun 2008 16:33:50 GMT
But... VBScript, it seems, doesn't recognise RFC822-formatted dates as being dates: isDate("Fri, 13 Jun 2008 16:33:50 GMT") returns false.13.06.08
So how am I supposed to get the date back out of my RSS file?
The only thing I can think of at the moment is to write a regexp to lift the relevant bits out of it. But that seems like a horribly complicated solution for a Friday afternoon when there's perfectly good drinking to be done, and I'm sure I'm not the only one who's come up against this problem, so I'm asking on here in the hope that someone can put me right