InfoPath Dev

Hilary,  That was absolutely it. And as you said in the sample file it really is crazy. I can see how the data fields would not match up with the data side having the Time appended to the date. Even though the Time was always 00:00:00, it was there. I thought that when I set up the SharePoint column to be Date Only that I had taken care ...

Hilary,  I added the date field as a test again and the data does have a T . 2012-01-27T00:00:00  Let me work on this for a bit and see if I can add the substring correctly and I’ll post my results. Thank you so much for your patience and your help. I found the InfoPathDev forum by searching for some other issues I was having and ...

Thank you so much for taking the time to build that example. I may be a little dense, so let me ask a couple of questions about what I am doing. When I want to see the XML of the data that is going to the Date field or the Start/End Date Picker field this is what I did. Open the Text or Date Picker Properties. Under the Data Tab in Binding it ...

The End Date date picker as XML showed only the date. The Date field in the repeating table as XML did show the Date00:00:00. So I tried changing the format of the control to show the Date without the * and selected do not diplay time. Didn't stick. I don't need the Date field in the repeating table to be a Date Picker, so I changed it to ...

I set the SharePoint Column up as Date only and when I look at the detail of the field in InfoPath, it says it is a Date Only Type. That said, and I am just getting into InfoPath, when I drug the datafields onto the form and selected Repeatable Table, it set up two fields in the Date column, one for Date and the other for Time. In as much as there ...

I am displaying data from a SharePoint List in an InfoPath 2010 Form. I am using a formatting rule to filter the data by Date. I have two fields: Start Date and End Date that specify the filter dates. The formatting rule basically hides the data that you don't want to see which leaves the data you want visible. Somewhat of a reverse ...

Should have done this first. Created a test table and manually entered values. Sum function worked as expected. I did notice that the product of a negative multiplicaiton was shown as a - and not a () which is an accounting treatment. I changed the format of the results fields in the SharePoint list from currency to number which produces a - sign ...

Thanks for the reply. The SharePoint List column I am totaling is a Text field formatted as Currency. Value in the field is actually created by a Workflow as text, because I ran into problems using a calculated field elsewhere. The actual value is the product of "Hours" X "Rate". Because SharePoint lists do not produce a ...

I am populating a Repeating Table from a SharePoint List. I want to use the Sum Function to total a column of numbers. The column can contain negative values. From what I can determine, the Sum Function totals the Positve values and ignores the Negative values. I am using a rule to filter the list and I apply the same rule to the Sum field. This ...