InfoPath Dev

 Jimmy,  Thanks. I'll insert that when they ask me for the next set of changes to that form. L Mac

 For those interested - the solution was: Set all date formats to yyyy-mm-dd (you may need to change the format saved when using Access DB tables) Convert date to integer in a second field using :   number(concat(substring(string(xdDate:AddDays(xdDate:Today(), -365)), 1, 4), substring(string(xdDate:AddDays(xdDate:Today(), -365)), ...

 For those interested - the solution was: Set all date formats to yyyy-mm-dd (you may need to change the format saved when using Access DB tables) Convert date to integer in a second field using :   number(concat(substring(string(xdDate:AddDays(xdDate:Today(), -365)), 1, 4), substring(string(xdDate:AddDays(xdDate:Today(), -365)), 6, ...

 I have a repeating table containing employees timecard details.  I need to count the number of absences in the last 12 months for a particular employee. The count is bound to the employee ID field.  I can count absences ("A") for a chosen employee, but I have a problem when I introduce a date filter.   Please ...

 Merrile,  Yes you can receive data, and write data to either MS SQL databases or MS Access Databases, and create a separate data connection to send out as an e-mail.  

I think that I have found the issue......   I have one date in Format :  dd/mm/yyyy   and the other is    yyyy-mm-dd Now that I have that part straight in my head can anyone help with the concat( substring-before  and substring-after) to reverse the first date?? Then I can translate() to get a ...

 I am having issues with counting data returned from an Access DB Table using InfoPath 2010. The data source (Timecards) is secondary.  I need to filter out all data greater than 12 months old. So far I have xPath as follows:  count(xdXDocument:GetDOM("Timecards")/dfs:myFields/dfs:dataFields/d:Timecards[@NotesMon = ...

I have a form to log temperatures of various pieces of equipment in several areas of operation. I want the form to display the Repeating Section the appropriate number of times, based on the area that you choose at the top of the form. I have a count that returns the number of times I need the section displayed. Any ideas on how to make the ...

 Thanks Hilary, I had made the assumption that absolute was needed as i was working in two data sources, and I had already had the count bound to the field where the value for @Project came from. Issue is now resolved. Thanks for your assistance.  L Mac.

 Hilary, Same count in a different form, this time the data source is secondary. Using rules I set the following Count:  count(xdXDocument:GetDOM("Maintenance")/dfs:myFields/dfs:dataFields/d:Issues[xdXDocument:GetDOM("Maintenance")/dfs:myFields/dfs:dataFields/d:Issues/@Project = . and ...