problem in sorting xml by date<xsl:sort select=""/>

Question

I am trying to sort my xml by date but its not working my xml and xsl r like this

<xsl:template match="/">
    <xsl:for-each select="news/item">
                        <xsl:sort select="date1" order="descending" />                                     

                          <xsl:value-of select="date1"/>                                

                  </xsl:for-each> 
</xsl:template>

MYXML

<news>
 <item>
<date1>January 1, 2010</date1>
 </item>
 <item>
  <date1>November 29, 2009</date1>
</news>


         Its displaying the result but not in sorted way..

Answer 1

xsl-sort does not "know" how to sort dates. It will use default to text sort, though you can specify numeric sort by using the data-type attribute.

There are several approches to solve this - add an attribute or change how you output the date to the source XML, so you have to a representation you can sort numerically.

Answer 2

You can try to use something like this:

<xsl:template match="/"> 
  <xsl:for-each select="news/item"> 
    <xsl:sort select="xs:date(date1)" order="descending" />
    <xsl:value-of select="date1"/>                                 
  </xsl:for-each>  
</xsl:template> 

Although, if you have control over the XML generation, I'd also put something like:

<date1 isoValue="20100101">January 1, 2010</date1>

And then use

<xsl:sort select="xs:date(date1/@isoValue)" order="descending" />

Answer 3

http://www.easytipsandtricks.com/browse/sort-xml-by-date-using-xslt Check this issue for the problem's solution. It uses xslt sort to sort xml by the dates in the xml.

cheers DSS