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/125320.aspxTue, 25 Apr 2023 18:25:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125320Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125320.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125320Here's the copy I took the screenshot from. Test with April 17, 2023 through April 27, 2023 and you should see the same result in my screenshot.https://www.infopathdev.com:443/forums/thread/125319.aspxTue, 25 Apr 2023 03:02:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125319hainh19840https://www.infopathdev.com:443/forums/thread/125319.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125319Hi Madam, I tried to change back date format and change to current year 2023. But, it still not work :(https://www.infopathdev.com:443/forums/thread/125318.aspxMon, 24 Apr 2023 21:51:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125318Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125318.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125318You have one holiday date in the wrong format in your XML. Dates are yyyy-MM-dd format. All of your holiday dates are from 2009. Are you testing with dates from 2009? If not, you may want to update those to current dates. I did that in a copy of the file, and then tested, and I believe the output is correct. I'd be concerned about this logic triggering a looping error, however. It seems EndDateWN gets changed a number of times and repeatedly executes Rule 2. I'm not sure if that is part of how this logic works, but I'd be a little concerned about it.https://www.infopathdev.com:443/forums/thread/125317.aspxMon, 24 Apr 2023 15:10:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125317hainh19840https://www.infopathdev.com:443/forums/thread/125317.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125317Dear Ms. Hilary, I have attached my form. Could you please have a look and help. Appreciate for your supporthttps://www.infopathdev.com:443/forums/thread/125316.aspxMon, 24 Apr 2023 14:42:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125316Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125316.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125316Can you attach your form template? I'll take a lookhttps://www.infopathdev.com:443/forums/thread/125315.aspxMon, 24 Apr 2023 08:51:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125315hainh19840https://www.infopathdev.com:443/forums/thread/125315.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125315Dear Ms. Hilary, I need your help, as I am try to add Holidays in my form. I have exported DayOftheWeek.xml form to add holiday, then I import again. File as below. But it's not work. It still calculate if I select those days. ---- 2009-02-22https://www.infopathdev.com:443/forums/thread/125298.aspxSat, 15 Apr 2023 00:50:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125298hainh19840https://www.infopathdev.com:443/forums/thread/125298.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125298Dear Ms. Hilary, Thank for your promt supporthttps://www.infopathdev.com:443/forums/thread/125295.aspxFri, 14 Apr 2023 16:29:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125295Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125295.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125295Thanks, that helped me find the issue. You need to set your daysOfTheWeek data connection to run on load is all. See attached screenshot. Just modify the data connection, click through the wizard and be sure to select the checkbox.https://www.infopathdev.com:443/forums/thread/125294.aspxFri, 14 Apr 2023 15:52:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125294hainh19840https://www.infopathdev.com:443/forums/thread/125294.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125294Dear Ms. Hilary, Thank for your question. I try to follow make rule follow this link https://social.msdn.microsoft.com/Forums/en-US/b72c47ad-4f83-49db-8372-3e336c2e1cde/infopath-rule-for-calculating-business-days?forum=sharepointcustomizationlegacy But when try to public or test form, it told me that function "AddDays" did not return value ....https://www.infopathdev.com:443/forums/thread/125292.aspxThu, 13 Apr 2023 14:25:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125292Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125292.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125292I am asking where you found the logic you are using in the current calculation so I can better understand it. I am assuming you did not develop these formulas yourself. What tutorial did you follow, please?https://www.infopathdev.com:443/forums/thread/125291.aspxWed, 12 Apr 2023 23:36:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125291hainh19840https://www.infopathdev.com:443/forums/thread/125291.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125291Dear Ms HIlary, I just want to Calculate the Total Day off if staff select Start Date and EndDate it will auto calcuate total day offhttps://www.infopathdev.com:443/forums/thread/125287.aspxWed, 12 Apr 2023 16:27:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125287Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125287.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125287Can you direct me to the instructions you followed for the logic currently in the form, so I know what to check it against?https://www.infopathdev.com:443/forums/thread/125284.aspxTue, 11 Apr 2023 15:26:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125284hainh19840https://www.infopathdev.com:443/forums/thread/125284.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125284Dear Team, Could you please help to check my form. I would like to ask your help. I made this Leave Request form, but something wrong, it does not calculate the date. I attached my form in this post. Thanks