How can I find the number of WorkingDays by selecting StartDate & EndDate in InfoPath-2010 ? (Excluding Saturday & Sunday. Means only WeekDays).
Please specify the Rule or the mehtod.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityThere is very detailed description of codeless (aka nocode) approach, just with rules:
the 2nd sentence of which is:
Updated: 5 more forms added at the bottom: “work days calculation (excluding weekends and holidays)”
There are more trivial/obvious approaches with the use of code.
Assuming you have access to Excel Services, these links may be useful to you:
If proposted codeless approaches don't appropriate in your case, another approach could be to create custom webservice to do this and call it from InfoPath. I used this method in my case.