>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

>Thread Prev - Filtering date values with XPath queries
>Thread Next - Re: Filtering date values with XPath queries

Re: Filtering date values with XPath queries

From: "Oleg Tkachenko [MVP]" <oleg@--!----!---------------.--->
To: NULL
Date: 5/4/2004 1:00:00 PM

Muhammed Inam wrote:

> Suppose I have the following XML data;
> <sgv>
>     <detail id="112233">
>         <datum>01.01.2000</datum>
>         ....
>     </detail>
>     .........
> </sgv>
> 
> What I'd like to do is selecting nodes that meet certain criteria. For this
> reason, I attempt to use the following command;
> 
>     myDom.selectSingleNode("//detail[datum >= '01.01.1999']")

There is date type in XPath, therefore there is no date comparison 
defined. Usual workaround is to have date value in YYYYMMDD format (you 
can get it using substring() and translate() functions) and then compare 
them numerically.
Alternatively you can use EXSLT date functions. If you under .NET - take 
a look at EXSLT.NET library.
-- 
Oleg Tkachenko [XML MVP]
http://blog.tkachenko.com

>Thread Prev - Filtering date values with XPath queries
>Thread Next - Re: Filtering date values with XPath queries

>Archive Index
>microsoft.public.xml Archive Home
>Recent entries

Altova Mailing List Archives

Re: Filtering date values with XPath queries