Hi All, This question is the same as my previous question but in add

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