InfoPath Dev

Sorry it took me so long to get back to this, but I finally did today.  It worked!   Thank you all so much for your help on this one. :)  Pinback

Jimmy, Thanks! You are correct...there is no "need" for my date to be formatted any particular way. I just want to get it to work. :) Potemkine, Thank you for this, I will try it first thing Monday morning.   Pinback

Thanks Patrick, Unfortunately, it is not up to me what software my organization uses, so I need to seek an XPath solution. Anyone have an idea? :) When I try to embed a function to do the work (example fn:year-from-dateTime), I get told it is an unknown function. I've tried 10 different functions...same result. Thanks in ...

Hello again great forum, NI is a XPathNodeIterator DOM is a XPathNavigator NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:Requests[@Begin_Date > '#6/1/1978#' ]", Me.NamespaceManager)  In the InnerXML, Begin_Date looks like this:      Begin_Date="2010-06-01 00:00:00" I need ...

Thanks, Jimmy! (sigh) You make it seem so simple. ;)

Hello, I have the following OuterXML: "<dfs:Room_Descriptions xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" Facility_Room="ABC" Facility="Building1" Room="F2"/>" The code watch I executed shows the OuterXML is stored as a string. I tried: Dim NI As ...

Hi, Is there an equivalent of the SQL "In" clause in XPath? Example: [@Max_E= 'AA'] [@Max_E='BB'] Do I have to write out @Max_E each time?  Thanks in advance, Pinback.

BINGO! :) You did it, Potemkine! Thanks so much! :) :)   Pinback

Hello Potemkine :) When I try: NI = DOM.Select("/dfs:myFields/dfs:dataFields/dfs:"My_Secondary_DataSource"[Facility='Mary']", Me.NamespaceManager) it reads the code, but the following line: MsgBox(NI.Count) returns a value of 0 despite the fact there are 4 instance of Mary in "My_Secondary_DataSource".

Hello, I am attempting to set up a filter using xPath and a Secondary DataSource (no filter applied as of yet). Dim DOM As Xml.XPath.XPathNavigator Dim NI As System.Xml.XPath.XPathNodeIterator Dim expr As XPathExpression DOM = Me.DataSources("My_Secondary_DataSource").CreateNavigator expr = ...