I am trying to create a rollup field using the DLRS tool. However, I am running into multiple problems.
Ideally, I would like to have my field find the most recent activity date and return the subject of that activity. I am unsure how to get it to return the subject and my initial attempts at building the SOQL have returned nothing but errors (saying its not a valid soql statement). And I'm not sure why! Any advice would be much appreciated. Below is the SOQL statement I built to find the activity with the most recent activity:
SELECT ActivityDate FROM Task WHERE ActivityDate < TODAY ORDER BY ActivityDate DESC LIMIT 1