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
2 replies
Subscribers
7 subscribers
Views
1204 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
i have used the function calworkdays to obtain the number of working days and i
nimishan
over 10 years ago
i have used the function calworkdays to obtain the number of working days and i am obtaining the result in number , how do i get in the format days , minutes and seconds??......
OriginalPostID-99451
OriginalPostID-99451
Discussion posts and replies are publicly visible
Parents
0
silambarasanr
A Score Level 1
over 10 years ago
Hi Nimisha,
If you are using Appian 7.2 and above,please take a look at the previous post
forum.appian.com/.../e-99262
Otherwise you can try this expression,
=index(split((ri!date2-ri!date1),":"),1)&" Days "&index(split((ri!date2-ri!date1),":"),3)&" Hours "&index(split((ri!date2-ri!date1),":"),4)&" Minutes"
Hope this helps!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
silambarasanr
A Score Level 1
over 10 years ago
Hi Nimisha,
If you are using Appian 7.2 and above,please take a look at the previous post
forum.appian.com/.../e-99262
Otherwise you can try this expression,
=index(split((ri!date2-ri!date1),":"),1)&" Days "&index(split((ri!date2-ri!date1),":"),3)&" Hours "&index(split((ri!date2-ri!date1),":"),4)&" Minutes"
Hope this helps!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data