topic Open deals past close date Segment in Tips, Tricks & Best Practices

Open deals past close date Segment

galvanA81 — Tue, 02 Dec 2025 13:22:02 GMT

hi everyone,

Im trying to create a segment that filters for open deals whose close date already passed. However Im not trusting that I can just select close date "is before Today" since as soon as I click Today the date is returned in the field and my guess this is not dynamic.

Is there a way to make the Segment filter criteria be dynamic?

Thanks in advance

Re: Open deals past close date Segment

karstenkoehler — Tue, 02 Dec 2025 13:26:04 GMT

Hi @galvanA81,

The filter you're looking for is "is more than 0 days ago". HubSpot uses the previous midnight as cut-off date, so "is more than 0 days ago" would be any close date before last midnight.

This is dynamic and would auto-update each day at midnight.

Best regards