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
4 replies
Subscribers
7 subscribers
Views
1951 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am trying to use the caladddays() function, but I keep getting this error:
jamelj
over 10 years ago
I am trying to use the caladddays() function, but I keep getting this error:
"Expression evaluation error at function 'caladddays': Cannot add more than a year's worth of days."
Is there a way to be able to add more that a year's worth of work days to a date? For example, how can I perfrom the following function:
caladddays(today(),263)
...
OriginalPostID-102385
OriginalPostID-102385
Discussion posts and replies are publicly visible
Parents
0
gauravg568
over 10 years ago
A workaround perhaps is to rewrite the expression as: =caladddays(caladddays(today(),262),1). If the number of days to add is a variable, in theory, you could create an expression that iterates and adds number of days in a year at a time until all days have been added.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
gauravg568
over 10 years ago
A workaround perhaps is to rewrite the expression as: =caladddays(caladddays(today(),262),1). If the number of days to add is a variable, in theory, you could create an expression that iterates and adds number of days in a year at a time until all days have been added.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data