>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.