InfoPath Dev

Dear 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

Can you direct me to the instructions you followed for the logic currently in the form, so I know what to check it against?

Dear Ms HIlary, I just want to Calculate the Total Day off if staff select Start Date and EndDate it will auto calcuate total day off

I 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?

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

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

Dear Ms. Hilary, Thank for your promt support

Dear 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-22

Can you attach your form template? I'll take a look

Dear Ms. Hilary, I have attached my form. Could you please have a look and help. Appreciate for your support

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

Hi Madam, I tried to change back date format and change to current year 2023. But, it still not work :(

Here'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.