Add 'n' number of days(excluding weekends and holidays) to a given date.

Question

Hi Community, 
 
 How to add 'n' number of days(excluding weekends and holidays) to a given date? We have defined holidays in Database. I know it is possible to define a Process Calendar with a list of non-working days and then use it in caladddays() function to achieve this outcome. As process calendars are not exportable and needs to be created in each environment separately, we are not considering this option at the moment. Having said that is there any alternative way to achieve this result? 
 
 Thanks, 
 Arun

Mike Schmitt · Accepted Answer

That should help you - my additional thought was, if you're storing your holidays in your database (as opposed to going through the fairly cumbersome and not-very-flexible process of defining them manually within your Appian environment), a brute-force approach would probably be feasible too - i.e. loop over a date range (like with a!forEach) and check each date for its "day of week" as well as whether it's in your holidays DB.

Add 'n' number of days(excluding weekends and holidays) to a given date.

Top Replies