[RESOLVED] Querying Private Message XML Files

[MartinLiss]

When you download your Private Messages in XMl format you get a file that looks like this

<?xml version="1.0" encoding="ISO-8859-1"?>

<!-- VBForums; http://www.vbforums.com -->
<!-- Private Message Dump For User MartinLiss; 01-29-2007 03:50 PM -->

<privatemessages>

<folder name="Sent Items">
	<privatemessage>
		<datestamp>2006-01-17 14:29</datestamp>
		<title>The title</title>
		<fromuser>MartinLiss</fromuser>
		<touser>JohnQ</touser>
		<message><![CDATA[yada yada.]]></message>
	</privatemessage>
	<privatemessage>
		<datestamp>2006-01-18 13:35</datestamp>
		<title>Hello There</title>
		<fromuser>MartinLiss</fromuser>
		<touser>Brad Jones</touser>
		<message><![CDATA[blah blah]></message>
	</privatemessage>
</folder>

</privatemessages>

Why is it that I can do the following to extrtact the PMs sent to me

Set oxmlNodeList = XMLdoc.documentElement.selectNodes("//privatemessage[touser='MartinLiss']/touser")

but I can't do this to get PMs after a certain date with code like this?

Set oxmlNodeList = XMLdoc.documentElement.selectNodes("//privatemessage[datestamp>'2007-01-01']/datestamp")

[penagate]

I believe MSXML doesn't support XSLT 2.0 and thus can't compare dates.

This post might assist.

[MartinLiss]

Resolved in this thread.