AddDays Formula Works until I Add 10 Days or More - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

AddDays Formula Works until I Add 10 Days or More

Last post 05-19-2016 02:37 AM by wilkies0106aw. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-17-2016 08:47 AM

    AddDays Formula Works until I Add 10 Days or More

     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.

     

  • 05-19-2016 02:37 AM In reply to

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

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

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.