There may be better way of doing this.
But How about this.
<xsl:apply-templates select="recorddata[symbol='MSFT' and
translate(date, '/', '')>01102003 and translate(date, '/',
'')<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