InfoPath: Calculate business days between 2 dates including leap year

The following articles describes the process to allow InfoPath to calculate difference between 2 dates. Required Fields: StartDate EndDate StartDateFirstDayOfYear StartDateLastDayOfYear EndDateFirstDayOfYear EndDateLastDayOfYear TotalDaysYearStartDate TotalDaysYearEndDate StartDateDayOfYear EndDateDayOfYear StartDateWeekOfYear EndDateWeekOfYear WeeksDifference DifferenceDays WeekendDays Businessdays Step 1 – Calculate First Day of Year Add new rule to “StartDate” Condition: None Rule type: Action Run action: Set field’s […]

Continue reading