Code

Re: current year function to filter by current year

Greg Collins — Tue, 28 Nov 2006 00:53:51 GMT

Glad you were able to get this resolved!

Re: current year function to filter by current year

Patrick Halstead — Wed, 22 Nov 2006 20:54:05 GMT

Cool!

Re: current year function to filter by current year

Michael71 — Wed, 22 Nov 2006 20:13:35 GMT

Success.....I found the code on the internet and edited the code. For future reference here is the Xpath to select a specific department and only the current year from an SQL Server database. I'm getting good.

sum(xdXDocument:GetDOM("TOSSReceive")/dfs:myFields/dfs:dataFields/d:TOSS/@monthlyExpenses[../@employeeDepartment = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:TOSS/@employeeDepartment and contains(../@expenseReportDate, substring(xdDate:Today(), 1, 4))])

Re: current year function to filter by current year

Michael71 — Wed, 22 Nov 2006 15:40:05 GMT

Does anyone know the Current Year Xpath function for InfoPath?

Re: current year function to filter by current year

Michael71 — Tue, 21 Nov 2006 23:00:08 GMT

Greg and InfoDev's,

I hard coded it, but need to find the Xpath that compares the current date. Here is the hard coded Xpath, and it just sums up for the expenseReportDate= "2006". If I can find the function that says current year in Xpath, I can solve it. Any help would be appreciated. Thanks.

sum(xdXDocument:GetDOM("TOSSReceive")/dfs:myFields/dfs:dataFields/d:TOSS/@monthlyExpenses[../@employeeDepartment = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:TOSS/@employeeDepartment and contains(../@expenseReportDate, "2006")])

Re: current year function to filter by current year

Michael71 — Tue, 21 Nov 2006 21:17:36 GMT

Yes Greg,

This does makes sense, but how do I only sum up monthly expenses for that current year. I'm guessing with a filter, but what type of Xpath for date do I include.

Re: current year function to filter by current year

Greg Collins — Tue, 21 Nov 2006 21:14:02 GMT

Keep in mind that the "display" of a date isn't necessarily representative of the stored value of the date. In InfoPath dates are stored in the sortable XML format: "yyyy-mm-dd" even if InfoPath displays them as "m/d/yyyy". So when working against a formatted date (or time or number) you must ignore the formatting and deal with the actual value stored in the field. Make sense?

current year function to filter by current year

Michael71 — Tue, 21 Nov 2006 20:52:45 GMT

How do I get the current year from a table that has dates in the 11/6/2006 Format. I'm trying to filter information only for the current year. I found a article about at

http://kjellsj.blogspot.com/2005/04/using-xpath-preceding-sibling-in.html

however it did not work in the Xpath box.