XPath formatDate questions - Hellllppppp!
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!

