Infopath: Get workdays between two days (remove sat and sun)

Last post 02-22-2019 08:00 AM by Hilary Stoupa. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

02-18-2019 07:29 AM

SG123
Joined on 08-21-2018
Posts 12

Infopath: Get workdays between two days (remove sat and sun)

Reply Contact

Hello All,

Need your support to help me write a formula to get workdays between two dates in InfoPath 2013. I have used below mentioned thread and wrote formula in my form.

https://www.meartechnology.co.uk/blog/2016/09/16/infopath-calculate-business-days-between-2-dates-including-leap-year/

This works fine, till the end date - year is changed. For example: Start Date: 18th Feb 2019 and End Date: 10th Jan 2020. Net work days: shows negative value.

Kindly help me how to resolve it. Or direct me to any specific thread, where I can find the solution.

Thanks. Your help will be appreciated.

Filed under: DateDiff, calculate total number of days, addDays(), #DefaultValue #DatePicker #InfoPath2013, #infopath2013, #datepicker

02-22-2019 08:00 AM In reply to

Hilary Stoupa
Joined on 06-20-2008
Posts 13,297

Re: Infopath: Get workdays between two days (remove sat and sun)

Mark as Not Answer Mark as Answer ...

Reply Contact

My guess would be that you need to re-run the calculation logic when the end date changes and that something isn't being re-run correctly. What happens if you change the start date after changing the end date? Does your calc then work correctly?

Hilary Stoupa

Page 1 of 1 (2 items)

InfoPath Dev