# Segment Filter by Date?

**URL:** <https://forum.mautic.org/t/segment-filter-by-date/32038>\
**Category:** Product Support\
**Created:** [May 10, 2024, 4:11pm UTC](https://forum.mautic.org/t/segment-filter-by-date/32038 "2024-05-10T16:11:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ricksimnett](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ricksimnett/32/1578_2.png) [@ricksimnett](https://forum.mautic.org/u/ricksimnett)\
**Post date:** [May 10, 2024, 4:11pm UTC](https://forum.mautic.org/t/segment-filter-by-date/32038/1 "2024-05-10T16:11:04Z")

</div>

**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?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [May 14, 2024, 6:56am UTC](https://forum.mautic.org/t/segment-filter-by-date/32038/2 "2024-05-14T06:56:39Z")

</div>

Hi, that would be

30 days or less then now:

last\_date ‘less or equal then’ -30 days

Why?

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