I have a xml file having following data

<?xml version="1.0" encoding="utf-8" ?>
<Company>
    <emp sDate="01-11-2007" eDate="30-11-2007">
        <Adult>90</Adult>
        <Child>50</Child>
    </emp>
    <emp sDate="01-12-2007" eDate="31-12-2007">
        <Adult>190</Adult>
        <Child>150</Child>
    </emp>

</Company>

and then i use this XPath to get the value

$CheckInDate = 20071225;

company/emp[concat(substring-after(substring-after(@sDate,'-'),'-'),substring(substring-after(@sDate,'-'),1,2),substring-before(@sDate,'-')) &lt; $CheckInDate and concat(substring-after(substring-after(@eDate,'-'),'-'),substring(substring-after(@eDate,'-'),1,2),substring-before(@eDate,'-')) &gt;= $CheckInDate]/Child

but it gives error that expression [u]has an invalid token.</u>

any sort of help will be appreciated.


I Love XML and family

__________________
I Love XML and family

Well you could simplify matters by breaking down the date extraction into separate parts and also by using substring(@eDate, 7, 4) to get the year.

--

Joe (Microsoft MVP - XML)

Thanks joefawcett, problem solved after applying your suggestion.


I Love XML and family