xml date compare

[dorothy2010]

Hi All,

I want to write a function that select some of xml nodes from a xml file
that xml file has a attribute is date 20/06/2011 12:00:00 PM
if i want to select all the node that is before 20/06/2011.

i know sql query has >>> date LIKE "20/06/2011%"

does xpath or .net has kind of method

thank you

[jmcilhinney]

If you want to compare dates temporally then you will need to create Date objects from the Strings contained in the XML. Depending on the circumstances, you might use CDate, Date.Parse, Date.ParseExact, Date.TryParse or Date.TryParseExact. You can then compare them like you would any other Dates, using mathematical operators.

[dorothy2010]

sorry, my question was abit confuse.

I want something like this>>

 xmlnodelist = xmldoc.SelectNodes("/namelist/names[@dir='20/06/2011 12:00:00 PM']/name")

that means it selects all the name nodes which @dir = 20/06/2011 12:00:00 PM

Now if I want to select all the name nodes which @dir LIKE '20/06/2011%' << I know the xml doesnt have LIKE, does any other simliar method that xml provide

[.paul.]

you could use LINQ to XML:

Public Class Form1
 
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim xml = _
        <?xml version="1.0" standalone="no"?>
        <root>
            <nameList>
                <name dir="20/06/2011 12:00:00 PM">name1</name>
                <name dir="20/06/2011 01:00:00 PM">name2</name>
                <name dir="20/06/2011 02:00:00 PM">name3</name>
                <name dir="21/06/2011 12:00:00 PM">name4</name>
                <name dir="21/06/2011 02:00:00 PM">name5</name>
            </nameList>
        </root>
 
        MsgBox((From node In xml...<nameList>.<name> Where [email protected]("20/06/2011") Select node.Value) _
               .Aggregate(Function(current, s) current & ", " & s).ToString)
 
    End Sub
End Class