xsl-list
[Top] [All Lists]

RE: Date Range in XSL

2003-04-16 09:01:45

There may be better way of doing this.
But How about this.
        <xsl:apply-templates select="recorddata[symbol='MSFT' and
translate(date, '/', '')&gt;01102003 and translate(date, '/',
'')&lt;04162003]" />

Thanks,
Raj...


-----Original Message-----
From: nshah(_at_)pershing(_dot_)com [mailto:nshah(_at_)pershing(_dot_)com]
Sent: Wednesday, April 16, 2003 8:37 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Date Range in XSL


I have a XML document in the following format.  The date is in mm/dd/yyyy
format.  Once i get a symbol, start date and a end date, how do i search
the XML doc for all records that fall within that date range for that
symbol.   For example, in the below format, when the user enters in a query
for MSFT and date range from Start date 02/16/2003 to End date  04/16/2003,
Only one record is shown.

<recorddata>
    <symbol>MSFT</symbol>
    <date>04/15/2003</date>
 </recordata>
<recorddata>
    <symbol>CSCO</symbol>
    <date>04/15/2003</date>
 </recordata>
<recorddata>
    <symbol>MSFT</symbol>
   <date>01/14/2003</date>
 </recordata>
<recorddata>
    <symbol>INTC</symbol>
   <date>01/13/2003</date>
 </recordata>

Thanks a lot for your help

Nehal



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



<Prev in Thread] Current Thread [Next in Thread>