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
12675 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
How do I calculate the difference in days between two dates I don't want ca
paule
over 8 years ago
How do I calculate the difference in days between two dates I don't want calworkdays() which gives working days. I don't want days360() which doesn't count certain dates (31st July for example).
OriginalPostID-156010
OriginalPostID-156010
Discussion posts and replies are publicly visible
0
Ramy Jaber
Appian Employee
over 8 years ago
Date-math can be done directly.
For example, =date(2015,7,31)-today()) returns '21' ( the number of days between today (10 July) and 31 July 2015)
You may have to wrap the function in "tointeger()" for formatting purposes, but the general idea is that it can be done directly where 1=one day. You can also use fractions for partial days (i.e. 1/24=.0416=one hour)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel