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
3 replies
Subscribers
7 subscribers
Views
1319 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
So I am wanting to determine the number of days late a user is in completing a t
mikec
over 9 years ago
So I am wanting to determine the number of days late a user is in completing a task and put that number in the Subject line of an email. For example: User A has a evaluation task due on 6/1/2015 and they receive a reminder email today. In the subject line I want to put "Your evaluation task is 4 days past due." So I inserted the following - tointeger(ri!duedate - today()). It gives me -4. Im like ok, then change it to tointeger(ri!duedate + today()). Well it does not like that!
Can someone help me with the syntax to get the total days late based on the due date and the date the email reminder goes out?
Thanks!
OriginalPostID-151629
OriginalPostID-151629
Discussion posts and replies are publicly visible
0
Conor Cahill
Certified Lead Developer
over 9 years ago
Did you try tointeger(today() - ri!duedate)? That should give the positive 4 you're looking for.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mikec
over 9 years ago
duh. Thanks conorc. I should go home now.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Richard
over 9 years ago
Don't feel bad, I've done the exact same thing
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel