https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/121981.aspxFri, 15 Nov 2019 19:05:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121981Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121981.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121981Here's a post that might help you - I've not tried it, however: https://social.msdn.microsoft.com/Forums/en-US/b72c47ad-4f83-49db-8372-3e336c2e1cde/infopath-rule-for-calculating-business-days?forum=sharepointcustomizationlegacyhttps://www.infopathdev.com:443/forums/thread/121980.aspxFri, 15 Nov 2019 19:02:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121980Ruenells0https://www.infopathdev.com:443/forums/thread/121980.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121980So this is working across all of the fields but I just realized it is not excluding weekends....any idea how to get that working in this?https://www.infopathdev.com:443/forums/thread/121979.aspxFri, 15 Nov 2019 17:53:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121979Ruenells0https://www.infopathdev.com:443/forums/thread/121979.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121979Thanks appreciate you guidance as always!!https://www.infopathdev.com:443/forums/thread/121978.aspxFri, 15 Nov 2019 17:31:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121978Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121978.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121978I've not used this style of calculation before, so I'm not super familiar with it - but I do know it makes use of some helper fields. You may need different helper fields for each set of calculations.https://www.infopathdev.com:443/forums/thread/121977.aspxFri, 15 Nov 2019 17:26:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121977Ruenells0https://www.infopathdev.com:443/forums/thread/121977.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121977ok so one more issue with this date to hours issue. I am doing the hours between submitted and masterdata then masterdata to credit then credit to tax. i should be able to apply multiple rules to fields shouldnt i ? It seems to be duplicating the number...just want to make sure it is possiblehttps://www.infopathdev.com:443/forums/thread/121976.aspxFri, 15 Nov 2019 17:22:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121976Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121976.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121976There isn't. If you copy the view by selecting everything and pasting it into your new form, you'll have to rebind all the controls to the new form's schema. Generally it is just simpler to recreate it.https://www.infopathdev.com:443/forums/thread/121975.aspxFri, 15 Nov 2019 16:52:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121975Ruenells0https://www.infopathdev.com:443/forums/thread/121975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121975THANK YOU !!! that fixed it....i don't suppose you know a quick way to copy a view from one form to another...completely separate form....any help would be appreciated.https://www.infopathdev.com:443/forums/thread/121974.aspxFri, 15 Nov 2019 16:45:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121974Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121974.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121974Sorry - I was looking for default values instead of at rules! Your XPath is incorrect. The correct condition for Rule 1 on HoursNewStatus would be: substring-before(xdDate:AddSeconds(xdDate:AddDays(../my:SubmitDate, substring-before(., ";")), 0), "T") != substring-before(../../my:Credit/my:CreditOwnerAssignedDate, "T")https://www.infopathdev.com:443/forums/thread/121973.aspxFri, 15 Nov 2019 16:15:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121973Ruenells0https://www.infopathdev.com:443/forums/thread/121973.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121973I just attached it to my response but here it is again.https://www.infopathdev.com:443/forums/thread/121972.aspxFri, 15 Nov 2019 16:09:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121972Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121972.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121972Do you have a copy of this form where you've tried to implement the logic you've linked to? You originally posted a screenshot that showed a rule inspector issue.https://www.infopathdev.com:443/forums/thread/121971.aspxFri, 15 Nov 2019 15:45:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121971Ruenells0https://www.infopathdev.com:443/forums/thread/121971.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121971my fields are SubmitDate and CreditOwnerAssignedDate so you wont exactly see those and I am attaching my form for you as well if it lets me.https://www.infopathdev.com:443/forums/thread/121970.aspxFri, 15 Nov 2019 15:39:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121970Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121970.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121970I'm looking at the HourDifference file you attached - and I don't see the field in your screenshot. I don't know how to help you figure out the issue when the screenshot doesn't match the provided form? Or is it a different form? When you say the forum won't "let" you attach your form - can you tell me what error you receive? Is the form too big?https://www.infopathdev.com:443/forums/thread/121969.aspxFri, 15 Nov 2019 15:10:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121969Ruenells0https://www.infopathdev.com:443/forums/thread/121969.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121969Its not allowing me to add my form so i guess I waithttps://www.infopathdev.com:443/forums/thread/121966.aspxFri, 15 Nov 2019 15:07:39 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121966Ruenells0https://www.infopathdev.com:443/forums/thread/121966.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121966Wouldnt let me add all of the files so here is the examplehttps://www.infopathdev.com:443/forums/thread/121965.aspxFri, 15 Nov 2019 15:06:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121965Ruenells0https://www.infopathdev.com:443/forums/thread/121965.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=121965So I had this working then I messed with it. I am following the attached example i got from https://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/?unapproved=9269&moderation-hash=ab0e755ed616146be7e0401f7d59da01#comment-9269 and it does work, however because I messed with it I am now getting this weird error saying that the field is not valid in the rule inspector and another error regarding the AddSeconds InfoPath InfoPath has encountered an error. The operation failed. The form's code contains an error. The following call in the form's code failed: Date.AddSeconds Unspecified error I have attached to example which is the HoursDifference and my form SoldTo. Please help me figure out what I am doing wrong