Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
7 subscribers
Views
3504 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi Everyone, Is there a way to get the list of all holidays(non-working days whi
chetany
A Score Level 1
over 10 years ago
Hi Everyone, Is there a way to get the list of all holidays(non-working days which may come on a non -weekend day) in a year which are set in the Appian calendar. Please let us know if there is any appian function or any other way.
Thank you in advance....
OriginalPostID-108048
OriginalPostID-108048
Discussion posts and replies are publicly visible
0
Michael Tan
Appian Employee
over 10 years ago
You can create a rule which determines if the date passed is a non-working week day. For example:
isNonWorkingWeekDay - and(not(calisworkday(ri!date)),weekday(ri!date,2)<6)
The above function uses the default calendar, so adjust the calisworkday function to use any of your custom calendars.
Next, I apply this rule to check through the next 365 days if any of them are non-working week days:
filter(rule!isNonWorkingWeekDay,todate(apply(fn!sum,ldrop(append(enumerate(365),365),1),today())))
The returned values will be the non-working, week days.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel