Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
7 replies
Answers
1 answer
Subscribers
5 subscribers
Views
5240 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
computing the difference from a date to now - need integer value.
jeffreyh851
over 8 years ago
I am computing the difference from a date to now and the report is defaulting the result to display 3 days 19 hrs 50 mins when I just need the integer value like "3". Advice?
OriginalPostID-229874
Discussion posts and replies are publicly visible
Top Replies
reginaldm377
over 8 years ago
+1
suggested
If I'm understanding correctly, you just want the day value from the result given (which in your case is 3 days 19hrs 50mins)?
+1
reginaldm377
over 8 years ago
If I'm understanding correctly, you just want the day value from the result given (which in your case is 3 days 19hrs 50mins)?
Cancel
Vote Up
+1
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
jeffreyh851
over 8 years ago
Correct, but I just want it to say 3, not 3 days.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Colton Beck
over 8 years ago
Would something like this work for you?
tointeger(today()-<someDate>)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
reginaldm377
over 8 years ago
You could do something like this - tointeger(now() - date(2016, 08, 15))
(you'll have to change the given dates accordingly) if done in SAIL or in an expression rule. If it's back-end (process model), capture the result in a process variable that is of type Integer so it auto-casts that value into an integer.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jeffreyh851
over 8 years ago
ColtonB, that worked! Thank you also reginaldm377.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Colton Beck
over 8 years ago
Glad I could help.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
reginaldm377
over 8 years ago
No problem :)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel