am09qx30

Please help me with a date formatting issue in xpath!

Ok stay with me here.

1. The post date on an item associated with an RSS feed from a Sharepoint 2007 blog site looks like this in the xpath expression builder (preview).

<pubDate>Mon, 04 Jun 2007 22:15:08 GMT</pubDate>

2. I create a current date as in the following: number(translate(ddwrt:TodayIso(), ':TZ- ', '')) which looks like this....

20070614160524

3. I am trying to get the date format in #1 above to look like the the number that results from #2. I try using the formatDate function as in the following:

ddwrt:FormatDateTime(string(pubDate),2057,"yyyymmdd")

I do not get the result I want, instead I get a null return.

Please help me for I know you are a superior technologist!