asked on

Add working days to datepicker field in infopath 2010

Hello experts,

How can I add working days in a given datepicker field in infopath 2010 and the result will be calculated in a second datepicker field as a calendar day, including weekends, without writing code?

Thanks

Mike McCracken

WHat do you mean without writing code?

Even adding 1 working day is difficult since if the next day is non-working you have to add 2 days then check again.

Do you need to worry about holidays?

mlmcc

Georgegian

ASKER

Hi mlmcc,

I mean that, is there a custom function that calculates the calendar day by adding working days is a given date? Custom function that uses Infopath object and functions and not code written in any other language like VB or C etc.

Georgegian

ASKER

Hi mlmcc

Regarding holidays, this custom function calculates only working days and ignores holidays.

Georgegian

Mike McCracken

I know of some in VB. I am not an InfoPath programmer so have no knowledge there.

Is this at all useful?
It is code but not in a language I recognize.

http://www.infopathdev.com/forums/t/7156.aspx

Basic algorithm it uses is to calculate the number of weeks (5 days in a business week) and the number of days remaining. it then adds the days one at atime ensuring the day added is a business day

mlmcc

ASKER CERTIFIED SOLUTION

klafkas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Georgegian

ASKER

Thanks klafkas,

i test your solution and it works.