+ Start a Discussion

Next Activity date similar to Last Activity in Opportunity Report

I need to have a date of a Next Activity task in an Opportunity report. I can show the Last Activity without a problem but I don't see any obvious way to get Next Activity. Is there some way that I can create a Next Activity field? Would I need to use workflow or an Apex trigger?


You'll need a trigger for this I think.  When an activity is inserted or updated, you'll need to check if it is earlier than the current next activity date and replace the field value. However, you also need to handle the case where an actvity is deleted and figure out the next activity of those that are left.