---
title: The Date and Time of the Last Case Activity for the Account | Rollup Helper Use Case Library
description: How to see the date and time of the last case activity for an account.
image: https://www.passagetechnology.com/hubfs/Date%20and%20Time%20of%20last%20Case%20Activity%20rollup.jpg
---

[GET DEMO](https://www.passagetechnology.com/any-product-one-on-one) **+1 (224) 655-6779

[![Trusted Salesforce service partner Passage Technology](https://www.passagetechnology.com/hubfs/2021/Nav-header-logo_PT.png) ](https://www.passagetechnology.com)

# The Date and Time of the Last Case Activity for the Account

[![Free Salesforce business guides to help admins/developers, project managers, sales managers, and decision makers. Download the free PDF series now: Reinventing Your Business, Reimagining Your Salesforce®.](https://www.passagetechnology.com/hubfs/2021/Essential-Salesforce-Guide_Helper-Suite.png) ](https://www.passagetechnology.com/en/essential-guide-for-salesforce-admins-developers)

## Problem: Users wants to see the last activity Date and Time from associated Cases on the Account.

## Solution: Create a rollup which rolls up the Last Modified Date.

The first step is to create a new custom field (using Date/Time as the data type) on the Account object. You can name the field, "Last Case Activity."

Create the rollup:

- Select *Account* as the Destination Object
- Select *"Last Case Activity"* as the Target field
- Select *Case* as the Child Object
- Use *Account ID - Case.AccountId* as the Relationship Field
- Select *Maximum* as the Select Type
- Select *Last Modified Date* as the Source Field
- Creating a new filter is optional
- Save and Run the rollup

![Date and Time of last Case Activity rollup](https://www.passagetechnology.com/hs-fs/hubfs/Date%20and%20Time%20of%20last%20Case%20Activity%20rollup.jpg?width=896&name=Date%20and%20Time%20of%20last%20Case%20Activity%20rollup.jpg)

Tags: [Account](https://www.passagetechnology.com/rollup-helper-use-cases/topic/account), [Account Management](https://www.passagetechnology.com/rollup-helper-use-cases/topic/account-management), [Case](https://www.passagetechnology.com/rollup-helper-use-cases/topic/case), [Case Management](https://www.passagetechnology.com/rollup-helper-use-cases/topic/case-management), [MAX](https://www.passagetechnology.com/rollup-helper-use-cases/topic/max), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper)

| [** Number of Open, Closed, In Process, Critical Cases On Account ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-open-closed-in-process-critical-cases-on-account) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Count Number of Campaigns on a Lead Record ** ](https://www.passagetechnology.com/rollup-helper-use-cases/count-of-campaigns-on-a-lead-record) |
| --- | --- | --- |

[ Optimize Sales Rep Reporting and Leaderboards in Salesforce ](https://www.passagetechnology.com/rollup-helper-use-cases/sales-rep-reporting)

[ Rolling Up Marketing Cloud Account Engagement (Pardot) Activity ](https://www.passagetechnology.com/rollup-helper-use-cases/rolling-up-marketing-cloud-account-engagement-pardot-activity)

[ Streamline Sales Pipeline ](https://www.passagetechnology.com/rollup-helper-use-cases/streamline-sales-pipeline)

[ Creating Grandchild Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/creating-grandchild-rollups)

[ Calculate the Number of Cases on a Salesforce Contact Record ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-cases-on-a-contact)

[ Creating Account Hierarchy Rollups without Coding ](https://www.passagetechnology.com/rollup-helper-use-cases/account-hierarchy-rollup-without-code)

[ Easily Create a Custom Last Activity (Task/Event) Date ](https://www.passagetechnology.com/rollup-helper-use-cases/last-activity-task-event-date)

[ Roll-ups Using Formulas Rather than Static Criteria ](https://www.passagetechnology.com/rollup-helper-use-cases/roll-ups-using-formulas-rather-than-static-criteria)

[ Identify The Primary Contact On An Account ](https://www.passagetechnology.com/rollup-helper-use-cases/identify-the-primary-contact-on-an-account)

[ Opportunity Line Item Schedule Rollups ](https://www.passagetechnology.com/rollup-helper-use-cases/opportunity-line-item-schedule-rollups)

© 2026 Passage Technology LLC All Rights Reserved. [Privacy Policy](https://www.passagetechnology.com/privacy-policy) | [Purchasing & Legal](https://www.passagetechnology.com/purchasing-and-legal) | [Terms of Service](https://www.passagetechnology.com/terms-of-service) | [App Security](https://passagetech.my.site.com/KnowledgeBase/s/article/Security-and-Privacy-Policy-1578080055496)

- [** ](https://www.facebook.com/passagetech)
- <https://x.com/passagetech>
- [** ](https://www.linkedin.com/company/passage-technology)
- [** ](https://www.youtube.com/channel/UCK2tzaCWVC7PmFCXrLirnZw)

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Passage Technology",
    "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/passage-technology"
  },
  "dateModified" : "2026-04-22T19:18:17.011Z",
  "datePublished" : "2016-03-24T22:16:47.000Z",
  "headline" : "The Date and Time of the Last Case Activity for the Account",
  "image" : [ "https://www.passagetechnology.com/hubfs/Date%20and%20Time%20of%20last%20Case%20Activity%20rollup.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/the-date-and-time-of-the-last-case-activity-for-the-account",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://www.passagetechnology.com/hubfs/Logo%20PT_colors_wide_on-white.png"
    },
    "name" : "Passage Technology LLC"
  }
}
```