xsl-list
[Top] [All Lists]

Re: Selecting the Latest Date

2006-02-07 21:10:24
You may try something like this

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"; version="1.0">

<xsl:output method="text" />

<xsl:template match="/data">
  <xsl:for-each select="items/date">
    <xsl:sort select="translate(., '.', '')" order="descending"
data-type="number" />
    <xsl:if test="position() = 1">
      <xsl:value-of select="." />
    </xsl:if>
  </xsl:for-each>
</xsl:template>

</xsl:stylesheet>

Regards,
Mukul

On 2/8/06, jeb501(_at_)sanmargroup(_dot_)com 
<jeb501(_at_)sanmargroup(_dot_)com> wrote:
Hi all,

From the below XML file how to pick the late date from date node..

 <?xml version="1.0" encoding="Windows-1252" standalone="yes" ?>
   - <data>
     - <items>
        <ref>28834</ref>
        <pdate>01.02.2006</pdate>
        <qty>5</qty>
        <clno>ax588</clno>
        <date>01.02.2006</date>
        <clrf>Normal 1</clrf>
        <clno>bx588</clno>
        <date>03.02.2006</date>
        <clrf>Normal 2</clrf>
        <clno>bx588</clno>
        <date>06.02.2006</date>
        <clrf>Normal 3</clrf>
    </items>
  </data>

 Regards
 Eugene

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--