---
title: Populate a Date Field on Case with the Most Recent Task for Order Sent | Rollup Helper Use Case Library
description: With Rollup Helper, view the date of the most recent task with a specific subject, such as Order Sent, that has been completed on a Case in Salesforce.
---

[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)

# Populate a Date Field on Case with the Most Recent Task for Order Sent

[![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: As an operations manager, I want to be able to easily see the date of the most recent task with a specific subject (Order Sent) that has been completed on a Case.

## Solution

1. Create a custom date field on Case (Order Sent)
2. Create a rollup
   
     1. Rollup Helper Step 1) Select Case as the object to roll up to.
     2. Rollup Helper Step 2) Select the field on Case that you would like to update (Order Sent).
     3. Rollup Helper Step 3)    
        
            1. Select Task as the child object with the Task.WhatId for the relationship.
            2. Select Due Date Only as the field to use as a source for your rollup
            3. Select Type:  Maximum
3. Create a filter
   
     1. Filter Step 1)  Keep the “Limit to” 1 record.
     2. Filter Step 2)  Keep the Sort order on Descending for Due Date Only
     3. Filter Step 3)
        
            1. Subject contains Order Sent
            2. Status equals Completed
4. Save the filter
5. Save and Run the rollup!

Tags: [Case](https://www.passagetechnology.com/rollup-helper-use-cases/topic/case), [Rollup Helper](https://www.passagetechnology.com/rollup-helper-use-cases/topic/rollup-helper), [Task](https://www.passagetechnology.com/rollup-helper-use-cases/topic/task)

| [** Viewing the Largest Quote on an Account ](https://www.passagetechnology.com/rollup-helper-use-cases/largest-quote-on-an-account) | [Rollup Helper Use Case Library](https://www.passagetechnology.com/rollup-helper-use-cases) | [ Number of Call Attempts to get a Discussion ** ](https://www.passagetechnology.com/rollup-helper-use-cases/number-of-calls-attempts-to-get-a-discussion-and-filtered-sorted-list-view-for-reps) |
| --- | --- | --- |

[ 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" : "Susan Harris",
    "url" : "https://www.passagetechnology.com/rollup-helper-use-cases/author/susan-harris"
  },
  "dateModified" : "2026-04-21T19:28:46.884Z",
  "datePublished" : "2016-07-08T14:51:44.000Z",
  "headline" : "Populate a Date Field on Case with the Most Recent Task for Order Sent",
  "mainEntityOfPage" : {
    "@id" : "https://www.passagetechnology.com/rollup-helper-use-cases/populate-a-date-field-on-case-with-the-date-of-the-most-recent-task-for-order-sent",
    "@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"
  }
}
```