Segment Filter by Date?

Your software
My Mautic version is: 5.03
My PHP version is: 8.1
My Database type and version is: mysql 8

Your problem
My problem is: I am trying to create a segment filter that is based upon a rolling date. In other words, when a contacts last_date (custom field) is 30 days or less from “todays” date, add them to the segment.

Kind of like a date difference function that returns number of days?

Hi, that would be

30 days or less then now:

last_date ‘less or equal then’ -30 days


A date 30 days ago is -30 days
Anything older then that is -31, -32, -100 etc.
Which means “-30 days or less”