Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Working with Hierarchical XML Data
Message
From
20/12/2006 14:02:35
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
To
20/12/2006 11:53:50
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
ASP.NET
Category:
XML
Environment versions
Environment:
VB.NET 1.1
Miscellaneous
Thread ID:
01178848
Message ID:
01179301
Views:
13
This message has been marked as a message which has helped to the initial question of the thread.
>Hey Viv,
>Another question relating to this XML file. I am looking at the XPATH string you are using to filter the returned nodes, and I was wondering if there way to filter the dates to dates that are less than today. I have been trying to use this string for the XPATH:
>
>"//G_NEW_DATE[NEW_DATE<'12-10-2006']/BID_CURVE_DATE"
>
>
>but it doesn't seem to find any record. The only thing I can think of is that the xml file can't tell that the field is a date, and therefore can't do a comparison.

Mike,

You are correct. The 'data' is all text. It is unfortunate that the source xml dates were not written in a sortable format. If you want to, you can create a stylesheet to transform the text of the date nodes into a YYYYMMDD format.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform