InfoPath Dev

but it is working fine in all other browsers without the ribbon being turned on..it does'nt work only in IE . Any thoughts?

Hey Hilary, "See attached. I've made a guess at the correct filter for setting the edoc notes from the default values."  Excellent work, thank you so much.  Using this formula, I managed to populate all 20 fields - even the 16 Edoc fields off of the check box.  :) "I added your default data source at the bottom ...

Thanks Hilary. So, no way to do this within Infopath? I could have swore I came across several other queries just like mine, where they said they used the substring-before to clear the extra characters, but did not provide detail how/where.

[quote user="Daryl K"]Last note: FWIW the field is configured for DateOnlyType, not date and time.[/quote] In SharePoint, the actual data type is datetime. That's why you end up with the blank time. SharePoint is just displaying date only, and not asking for time values when the data is entered.

In SharePoint, you are seeing a formatted date. When InfoPath queries the list / library, it returns the actual value - which is a date time (with a blank time). So - the issue you are going to have here is that you can't use a formula to tidy this up in InfoPath, because, as you mentioned, you are using this data as the values for a combo ...

Last note: FWIW the field is configured for DateOnlyType, not date and time.

Interestingly, I noticed something else; Infopath reformats the date, so that in the SharePoint column it looks like this: 10/15/2018 but comes across into the combo box as 2018-10-15T00:00:00. I don't care so much about "/" becoming "-" but why does it move the year to the front?

I have an InfoPath form that pulls several columns of data from a SharePoint list into combo boxes. One of the columns is a date field, and even though it is formatted correctly on the SharePoint side as date-only InfoPath adds a time component so that it always looks like this: 2018-10-15T00:00:00. I have done a bit of research and read many ...

See attached. I've made a guess at the correct filter for setting the edoc notes from the default values. I added your default data source at the bottom of the form - is the Country there text or an ID? I'm guessing it is text.... I put the value of your Country4 field under the dropdown so you can see it - it is going to be an ID. If you ...

Sorry for the confusion - I originally was getting values from Default-Values based on Sales Org for those four fields (Payment Terms, Inco Terms, etc.), but now everything (those 4 fields, as well as the 16 Edoc fields) needs to be from Country instead. "Are you saying you need to get a value from Default-Values where the country matches ...