https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/106799.aspxThu, 26 May 2016 15:56:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106799joegood0https://www.infopathdev.com:443/forums/thread/106799.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106799Thanks for the update. I have removed the getuserbyprofilename, instead just setting the value from the username() to the accountid on a list. I can pull the required data filtering on username. It appears to work with no errors. I will make the changes suggested. Thankshttps://www.infopathdev.com:443/forums/thread/106798.aspxThu, 26 May 2016 15:21:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106798Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106798.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106798When you add qRules to a form, you are adding code. This then puts the form in the SharePoint Sandbox, which can cause a variety of different behaviors than seen in the same form previously. Are you running the data connection on load? If so, change that (walk through the data connection again, deselect the checkbox that indicates you want the data to load when the form opens). On the QdabraRules finishedLoading node, add a rule with the condition finishedLoading = true. Set the query username field in your data connection to the userName() function in InfoPath, then execute the query and see if that resolves the issue. Attach a copy of your form if you need a hand with this (under the Options tab in a reply).https://www.infopathdev.com:443/forums/thread/106797.aspxThu, 26 May 2016 15:15:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106797joegood0https://www.infopathdev.com:443/forums/thread/106797.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106797Meant to say its in the browserhttps://www.infopathdev.com:443/forums/thread/106796.aspxThu, 26 May 2016 15:13:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106796joegood0https://www.infopathdev.com:443/forums/thread/106796.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106796Hi In preview it works fine no problems. After publishing and opening the form it comes up with the error.https://www.infopathdev.com:443/forums/thread/106794.aspxThu, 26 May 2016 15:06:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106794Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106794.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106794Is this in the browser? Or in preview / filler?https://www.infopathdev.com:443/forums/thread/106793.aspxThu, 26 May 2016 15:04:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106793Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106793.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106793Yeah, you'll have to get the first value, then the second value and add them together.https://www.infopathdev.com:443/forums/thread/106790.aspxThu, 26 May 2016 12:01:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106790joegood0https://www.infopathdev.com:443/forums/thread/106790.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106790Hilary I've noticed a strange behaviour. My form with Qrules and a secondary data connection (GetProfileByUsername) errors on opening. The following query failed: GetUserProfileByName (User: , Form Name: tf1, IP: , Connection Target: , Request: , Form ID: urn:schemas-microsoft-com:office:infopath:tf1:-myXSD-2016-05-26T11-51-03 Type: DataAdapterException, Exception Message: The remote server returned an error: (500) Internal Server Error. A user with the account name could not be found. ---> However the same form without Qrules works with no issue.https://www.infopathdev.com:443/forums/thread/106786.aspxThu, 26 May 2016 06:43:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106786joegood0https://www.infopathdev.com:443/forums/thread/106786.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106786HI Hilary I did see a similar example from the webinar. In regards to a half day using Qrules DateDiff command, It would be relatively straight forward to calculate the minutes and then convert to hours. Doing it this way though you lose the weekdays component. pity we cant have /component=weekdays, /totalminutes Thanks for your input.https://www.infopathdev.com:443/forums/thread/106784.aspxThu, 26 May 2016 00:03:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106784Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106784.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106784Attaching a sample that at least shows an hours calc excluding weekends based on an 8 hour day.... sorry, I didn't have a chance today to do much more than this, but hopefully it gives you a jump start. Save the file locally, right click & select design, from there you can preview & look at the logic.https://www.infopathdev.com:443/forums/thread/106779.aspxWed, 25 May 2016 15:09:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106779Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106779.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106779I'll try to put together a little sample later today and attach it to a reply. :)https://www.infopathdev.com:443/forums/thread/106774.aspxWed, 25 May 2016 06:31:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106774joegood0https://www.infopathdev.com:443/forums/thread/106774.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106774Hello Hilary Our half day is 4 hours. for the leave request user enters start date and end date, with time as an option. I had a thought about just using option of morning or afternoon. Thanks for any advise you can give Jhttps://www.infopathdev.com:443/forums/thread/106769.aspxWed, 25 May 2016 00:40:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106769Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/106769.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106769What is a half day for you? 4 hours? 12 hours? :) Can you give me a little more info about what you might enter & what you'd expect for an outcome?https://www.infopathdev.com:443/forums/thread/106760.aspxTue, 24 May 2016 13:54:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106760joegood0https://www.infopathdev.com:443/forums/thread/106760.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=106760Hello I am evaluating qrules for a leave request form. However we also need to calculate half days. I specified the controls as date time. I also want to exclude weekends. can some one point me in right direction to achieve the outcome. Thanks in advance