>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

From: "David Carnes" <davidc@----------------.--->
To: NULL
Date: 5/5/2004 9:17:00 AM

Muhammed:
I have some XML that has a date attribute (in a string datatype) that comes
to me in MM/DD/YYYY format.  I can sort on it by using a combination of
concat and substring functions:

concat(substring(@act_start_date, 7, 4), substring(@act_start_date, 1, 2),
substring(@act_start_date, 4, 2)

HTH!
Dave


"Muhammed Inam" <fwr> wrote in message
news:egbHyjaMEHA.2704@T......
> Hallo,
>
> 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']")
>
> However, this code, is returning nothing. How can I force XPath engine to
do
> a date comparison? (if it's possible, at all.) Or, is there any other
> solution to this?
>
> Regards,
>
>

>Thread Prev - Filtering date values with XPath queries
[Thread Next]

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

Altova Mailing List Archives

Re: Filtering date values with XPath queries