Re: [xsl] Selecting the Latest Date

Subject: Re: [xsl] Selecting the Latest Date
From: jeb501@xxxxxxxxxxxxxxx
Date: Wed, 8 Feb 2006 10:01:20 +0530
Mukul,

Thanks for the lighting response,

I am already using the below stylesheet to get my required output in html
files.

I like to pick the value of Date node which is largest of the three, which
i like to keep it in the

last column of my html sheet.



<?xml version="1.0" encoding="ISO-8859-1" ?>
    - <xsl:stylesheet version="1.0" xmlns:xsl="
    http://www.w3.org/1999/XSL/Transform";>
      - <xsl:template match="/">
        - <html>
          - <body>
              <h4>Test Report</h4>
            - <table border="1" cellpadding="4" cellspacing="0">
              - <tr bgcolor="#9acd32">
                  <th>Ref</th>
                  <th>Date</th>
                  <th>Qty</th>
                  <th>S Date</th>
              </tr>
              - <xsl:for-each select="data/items">
                - <tr>
                  - <td>
                      <xsl:value-of select="ref" />
                  </td>
                  - <td>
                      <xsl:value-of select="pdate" />
                  </td>
                  - <td align="right">
                      <xsl:value-of select="qty" />
                  </td>
                  <td>
                  the selected value should come here...
                  What xsl syntax i have to use here...

                  </td>
                </tr>
              </xsl:for-each>
            </table>
          </body>
        </html>
      </xsl:template>
    </xsl:stylesheet>

  Thanks again.

  Regards
  Eugene



             Mukul Gandhi
             <gandhi.mukul@gma
             il.com>                                                    To
                                       xsl-list@xxxxxxxxxxxxxxxxxxxxxx
             08.02.2006 09:40                                           cc
             AM
                                                                   Subject
                                       Re: [xsl] Selecting the Latest Date
             Please respond to
             xsl-list@xxxxxxxx
              lberrytech.com







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@xxxxxxxxxxxxxxx <jeb501@xxxxxxxxxxxxxxx> 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

Current Thread