Smart CRM: Rollup properties with Date objects

HubSpot Ideas
,
1

Feature Idea
Allow Rollup properties to operate on date and datetime properties, not just numbers.
Currently, there is the possibility of using Property Sync properties on dates from associated CRM objects based on conditions. However, dates also lend themselves to aggregations such as taking the minimum or maximum date. Using property sync in this case would mean that the conditions that may be enforced on said dates are simply (`First created` or `More recently created`) which might disregard important business context.
This could be a useful addition to the Smart CRM product building on the Rollup property work already done for Number properties and extending it to dates.

Key behaviors:

  • Supported rollup types for dates

    • Min: earliest date among associated records.
    • Max: latest date among associated records.
    • (Count/Sum/Average stay numeric-only or behave consistently as today.)

  • Supported formats

    • Source: Date picker or Date & time picker properties on the associated object.
    • Target (rollup) property:
      • Field type: Rollup
      • Only allow date output option.

  • Filtering

    • Keep existing rollup filters (conditions and association labels).

  • Use cases

    • Company: last interaction date across Tickets/Deals.
    • Company: earliest renewal date across subscriptions.
    • Contact: last order date across Orders.
2

For any wanderers, this has since been implemented by HS. In rollup properties you are able to use the Earliest Dateand Latest Date criteria to achieve what the post above mentioned.