Future Activity
I'm trying to create a report that has the following criteria:
List the very next activity for the contact/account.
I have another report that shows the last activity using Activity."Task Due Date" = MAX(Activity."Task Due Date" BY Contact."Contact ID") .. I wasn't sure if there was a formula like this that would show a future activity (only the very next activity, not all future activities). I appreciate any help!
Thanks,
Colin
List the very next activity for the contact/account.
I have another report that shows the last activity using Activity."Task Due Date" = MAX(Activity."Task Due Date" BY Contact."Contact ID") .. I wasn't sure if there was a formula like this that would show a future activity (only the very next activity, not all future activities). I appreciate any help!
Thanks,
Colin
0