9 Replies Latest reply on Sep 4, 2017 9:08 AM by TomTheiler

    Request Offering Fulfillment Target Date/Time Field excluding weekends

    TomTheiler Apprentice

      In our Request Offerings we have set a Date/Time Field 'Fulfillment Target'. There the end user can see, when he can expect the request to be completed. By default on most of our offerings, it is 5 days. He also has the possibility to set this date later in the future, but not earlier.

       

      Unfortunately, the formula 'AddDays' includes also weekends, where we usually do not work. Is there a way to exclude weekends?

       

      Is:

      Created On: Thursday 08/17/2017 12:00

      Fulfillment Target: Tuesday 08/22/2017 11:59

       

      Should be:

      Created On: Thursday 08/17/2017 12:00

      Fulfillment Target: Thursday 08/24/2017 11:59

       

      Capture.PNG