XPath for finding an XMLSubset for dates

[Dhiren Joshi]

I have an XML ..

<data>
<rec>
<field>2003-11-03 13:40:49.0</field>
<field>12q</field>
<field>qwe</field>
                </rec>
 
<rec>
<field>2003-12-03 13:40:49.0</field>
<field>q</field>
<field>345qwe</field>
                </rec>
 
<rec>
<field>2004-11-03 13:40:49.0</field>
<field>q</field>
<field>qwe</field>
                </rec>
 
<rec>
<field>2004-10-03 13:40:49.0</field>
<field>q</field>
<field>qwe</field>
                </rec>
<rec>
<field>2004-9-03 13:40:49.0</field>
<field>q</field>
<field>qwe</field>
                </rec>
<rec>
<field>2004-8-03 13:40:49.0</field>
<field>xfg</field>
<field>qwe</field>
                </rec>
                .
                .
<rec>
<field>2004-6-03 13:40:49.0</field>
<field>q123</field>
<field>weERT</field>
                </rec>
<rec>
<field>2004-10-03 13:40:49.0</field>
<field>q</field>
<field>qwe</field>
                </rec>
</data>
 
  

I wish to extract the records which are between 2004-6-03 13:40:49.0 to 2004-10-03 13:40:49.0 date .
I wish to do it using XSL.
I used this XPath ..//rec[field[1] >= '2004-06-03 13:40:49.0'][field[1] <= '2004-10-03 13:40:49.0'] But it returns me an empty node set.
What I am missing ... ?

Thanks
Dhiren

[Madhav Lakkapragada]

I used this XPath ..//rec[field[1] >= '2004-06-03 13:40:49.0'][field[1] <= '2004-10-03 13:40:49.0'] But it returns me an empty node set.
What I am missing ... ?

Try the XPath :

..//rec[field[1] >= '2004-06-03 13:40:49.0']|| ..//rec[field[1] <= '2004-10-03 13:40:49.0']

Let us know if this works.

- m

[Dhiren Joshi]

didnt work out.
Infact anywhere I use the <= or >= sign for date the records found are empty nodeset.
Seems like XSL is unable to do a date compare.

Thanks
Dhiren