Re: AddDays Formula Works until I Add 10 Days or More

wilkies0106aw — Thu, 19 May 2016 09:37:12 GMT

Don't worry about this. I redid all my rules to take account of weekends and public holidays.

AddDays Formula Works until I Add 10 Days or More

wilkies0106aw — Tue, 17 May 2016 15:47:06 GMT

All,

I've a form with a start date and an end date. I use this two dates to calculate the difference in number of work days, excluding weekends and public holidays.

I then have a 'list of sections'. Each section contains a date, and two text fields.

The first date in the list is the start date, then very simply I use the AddDays function to add a new date to the next date picker in the next section.

If I have less than 10 working days, my dates flow as expected.

Once I go over 10 working dates, my date on one field. HDate3 increase by an extra day. I can't figure out why.

The formula is set on HDate 2 as follows: addDays(HDate1, 2). It 's the only field on which the 'jumping' happens.

I've recreated the section and fields numerous times.I can't understand why it would jump.

General

Re: AddDays Formula Works until I Add 10 Days or More

AddDays Formula Works until I Add 10 Days or More