[progress Communities] [progress Openedge Abl] Forum Post: Re: What Is The Best Way To Loop...

[Paulh0763]

Hi Jason, Thanks for the snippet of code but it is pulling in the same date for all Partner records...what am I missing. I need the view to display this expression field with the most recent date... var activityArr = rbv_api.selectQuery("SELECT startDate FROM appointment WHERE R529621 = '10143598' ORDER BY startDate DESC", 1); if (activityArr.length > 0) { var lastDate = new Date(activityArr[0][0]); } return lastDate; R629621 = related Activity type and 10143598 = Partner - Breakfast

Continue reading...