Does anyone have ideas on how I might filter a dataview of an xml file with a <date> tag that looks like <date>2009-09-30T00:15:13.157Z</date>. Preferably I would like to only show the current month.
'setup httpWebReqeust to send the request
Dim address As New Uri(sUri)
Dim theRequest As HttpWebRequest = TryCast(WebRequest.Create(address), HttpWebRequest)
theRequest.Credentials = New NetworkCredential((sAPIKey & "%" & ctu), ctp)
theRequest.Method = "GET"
theRequest.ContentType = "application/vnd.ctct+xml"
Using theResponse As HttpWebResponse = TryCast(theRequest.GetResponse(), HttpWebResponse)
'load dataset with xml response
Dim xtr As New XmlTextReader(theResponse.GetResponseStream())
xtr.ReadString()
Dim dsct As New DataSet()
dsct.ReadXml(xtr)
...
Go to the complete details ...