InfoPath Dev

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.

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?

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.

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")])

Does anyone know the Current Year Xpath function for InfoPath?

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))])

Cool!

Glad you were able to get this resolved!