InfoPath Dev

Thanks 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. Thanks

Meant to say its in the browser

Hi In preview it works fine no problems. After publishing and opening the form it comes up with the error.

Hilary 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: ...

HI 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.

Hello 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 J

Hello 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