Function: substring in MSXML 3.0
Posted on 2003-11-26
I need an xpath query to extract nodes based on a given month and year. The following code snippet works fine in MSXML4, but errors with unknown method in MSXML3. I have checked the MS website and substring is supported in version 3 of MSXML.
Unfortunately, I must use MSXML3. Can anyone assist?
xxx.SelectNodes("PageData[Data[Date[substring(.,1,7) =" & Chr(34) & Year(dtCurViewMonth) & "/" & Month(dtCurViewMonth) & Chr(34) & "]]]")