InfoPath Dev

Well - we have a tool that can create an XML for each row - it isn't going to send to the manager, but you could always add some workflow for that... If third party tools aren't an option, you'll need to write code for this.

Hi - your XML data connection does not have query fields, so the first two actions in your rule aren't really doing anything. In the fields task pane, drag the secondary data source onto your form so you can see the data and run those two actions and you should see that they make no difference - when that XML data source loads, it will have ...

I did a quick test - I can view source on my email from SharePoint - what version of IP / ShP are you using? I'm going to email you via the forum - and you can forward one of your emails to me and I'll see if I can view source on it....

Hmmm. So, if you generated an XML for each PIN, even if the user hadn't started it herself, that would solve your issue? We have a tool that can be used to generate XML from an Excel file - so you could get your SharePoint list data into Excel and generate XML for the rows you want. I'm also wondering if there is a way in a web part to ...

Hey - sorry you sort of ended up talking to yourself, but thanks so much for posting your final work around for others, that is much appreciated!

So - in your initial post, you said the date was incorrect - now you are saying it isn't populating? Can you clarify the issue?

I'm thinking you'll need to combine BETWEEN w/ addDays - something like: concat("ModifySqlQuery /dsname=ByteproAGS /where=where Status.ClosedDate between '",  addDays(today(), -365),  "' and '", today(), "' and Loan.LoanWith is not null and Borrower.SSN='", SSN, "'")

How odd. Everything is in the same time zone?

I can't think of a way to do this - I'm not sure how to get ShP to not include Submitted by. I did a search (and maybe you have found and tried this already) and found this blog post - maybe give it a try? If you do try it - would you post back and let me know if it worked? EDITED: Reading the comments on that blog post leads me to ...