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
5244 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)?
Parents
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
Reply
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
Children
No Data