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
5 replies
Subscribers
8 subscribers
Views
1636 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi All, This question is the same as my previous question but in add
aswinb
over 10 years ago
Hi All,
This question is the same as my previous question but in addition I am providing the code also. I have a query rule called rule!PSA_PSAAssignmentsPSACountBtwTimeFrame which will return a bunch of dates and then I am providing that to a datetext function to create a list of dates of the following format : "MM/yyyy" which is stored in local!monthYears. If I have a bunch of dates like 5/31/2014, 5/31/2014, 6/1/12014 it would drop off the last value which is 6/1/2014. Don't know why this is happening. Any ideas as to what to do to solve this problem. the code is below:
local!list:if(rule!COMMON_IsNullOrEmpty(ri!start), null, if(rule!COMMON_IsNullOrEmpty(ri!end), null, rule!PSA_PSAAssignmentsPSACountBtwTimeFrame(cons!PSA_MILESTONE_TYPES[1],ri!start,ri!end).Milestone_Date)),
local!monthYears: datetext(local!list,"MM/yyyy"),
Thanks,...
OriginalPostID-106757
OriginalPostID-106757
Discussion posts and replies are publicly visible
Parents
0
aswinb
over 10 years ago
my working calendar is UTC-5:00 Eastern Time(America/New_York) in appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
aswinb
over 10 years ago
my working calendar is UTC-5:00 Eastern Time(America/New_York) in appian.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data