Open deals past close date Segment

[galvanA81]

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

[karstenkoehler · Accepted solution]

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