Show annual work day without holidays

If you have list of holidays ,then by using calworkdays() function we can calculate number of work days between two dates  .

load(
  local!holidays: {
    "1/26/2014",
    "5/10/2014",
    "8/15/2014"
  },
  /*According to the calendar defined for the system.*/
  calworkdays(
    todatetime(
      "1/01/2014"
    ),
    todatetime(
      "12/31/2014"
    )
  ) - count(
    local!holidays
  )
)

The best place to find this is in the Process Calendar Settings:

https://docs.appian.com/suite/help/latest/Process_Calendar_Settings.html

Here, you can create calendars that define the working days for the year that can be saved. Then, when you call the several functions that start with "cal" (e.g. caladddays, calisworkday), specify the calendar name you want to use and the calculation will take those holidays into account.

Thanks you for answering. I´m goint to fit the code with mine.

Thanks a lot Peter. I was looking at the information but understood it at 100%

Hi Peter, 

Is it possible to build a front-end UI for the business to be able to manage their own calendar?

Hmm, I thought that there was a way to create a new process calendar from a plug-in, but I don't see it in the AppMarket. I'm not aware of any other OOTB way to update the calendar programatically, but you could probably create your own plug-in.

The other option you have is to create your own calendar and save the holidays / working hours in the database. Then, you could create any kind of UI you want to manage that, although you'd need to query from the database and do some expression manipulation to actually use the calendar.

Thank you for the quick response!