# Extra refine filter conditions - Rolling date range **URL:** \ **Category:** HubSpot Ideas\ **Tags:** segments, workflows\ **Created:** [October 13, 2020, 1:53pm UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693 "2020-10-13T13:53:01Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Stevie-Kv](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/stevie-kv/32/97206_2.png) [@Stevie-Kv](https://community.hubspot.com/u/Stevie-Kv)\ **Post date:** [October 13, 2020, 1:53pm UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/1 "2020-10-13T13:53:01Z")
**Context/Story** I have an email marketing campaign that gets sent out via a contact workflow, should enough time pass and the contact meets the criteria again in the future, they could re-enrol into the workflow and see the emails again. **What I want to do** For reporting/suppression purposes, I want to be able to create lists that look at the most recent email sends, not the first. To do this I want to look at the past X days email activity happened. For example, contact was sent email - Marketing email activity: was sent **Example email** within the last 30 days AND - Marketing email activity: clicked **Example CTA** in **Example email** **Why I can’t do it** While we do get options to refine filter conditions further into the list criteria, it’s very limited and relies on static dates, not a rolling date range. ![33002iA6146919E2CF2419.PNG](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/5/c5147cc8dca27341efddf3fcfaf58566bb8a49df.png) **Proposed solution** I want to see further options in the refine filter condition options. Rolling date ranges would be a great start. There are many other cases where this kind of refined filter would be helpful, I’d like to see it as a usable filter in workflows and the report builder, not just list building. ---
**Author:** ![oauckland](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/oauckland/32/52876_2.png) [@oauckland](https://community.hubspot.com/u/oauckland)\ **Post date:** [December 10, 2020, 9:52am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/2 "2020-12-10T09:52:18Z")
Agree, would be very useful. We use recurring emails a lot so want to be able to filter on those who have ‘opened or clicked within past \_\_ days period’. ---
**Author:** ![JWienkamp](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jwienkamp/32/57633_2.png) [@JWienkamp](https://community.hubspot.com/u/JWienkamp)\ **Post date:** [September 17, 2021, 11:12am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/3 "2021-09-17T11:12:38Z")
Really need this! It’s actually possible to use rolling date ranges filter on Form submissions - so why not on received Marketing Emails? I dont see a proper workaround for this at the moment 😞 ---
**Author:** ![MagdaPrichodko](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/magdaprichodko/32/8776_2.png) [@MagdaPrichodko](https://community.hubspot.com/u/MagdaPrichodko)\ **Post date:** [March 20, 2023, 9:47am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/4 "2023-03-20T09:47:19Z")
Absolutely!!! I’m surprised the rolling range is not available as for other properties… ---
**Author:** ![EKato](https://avatars.discourse-cdn.com/v4/letter/e/fbc32d/32.png) [@EKato](https://community.hubspot.com/u/EKato)\ **Post date:** [January 4, 2024, 12:59am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/5 "2024-01-04T00:59:13Z")
100%. Having a rolling date option would be amazing and gives flexibility how we design our workflow and sends emails. ---
**Author:** ![CHawkins](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chawkins/32/87643_2.png) [@CHawkins](https://community.hubspot.com/u/CHawkins)\ **Post date:** [January 26, 2024, 12:56pm UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/6 "2024-01-26T12:56:14Z")
Running into this same issue. If you are using campaigns, I think the campaign influence filter could be a viable workaround… ![Screenshot 2024-01-26 at 8.07.24 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/a/a9ae7337890a49d5c1ceafc1ead87d50fdbe1e45.png) ---
**Author:** ![christa](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/christa/32/35493_2.png) [@christa](https://community.hubspot.com/u/christa)\ **Post date:** [July 30, 2024, 12:22am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/7 "2024-07-30T00:22:17Z")
A use case where we ran into this limitation is that we want to put the parameter on a specific email, not a campaign or all marketing emails. **Example** : In an If/Then branch of a workflow. IF a person received the specific marketing email called ‘Action Based | A’ less than one day ago, we want to delay sending the email ‘Action Based | B’ until the next day. Currently, we cannot refine the marketing email criteria to take this ‘less than 1 day ago’ into account on the specific email of interest. We are only given date range options when looking at marketing email refinement criteria. The date range option is limiting for evergreen initiatives like in a workflow that will have ongoing enrollments and send date considerations. ---
**Author:** ![Hyroxware](https://avatars.discourse-cdn.com/v4/letter/h/51bf81/32.png) [@Hyroxware](https://community.hubspot.com/u/Hyroxware)\ **Post date:** [November 4, 2024, 11:15am UTC](https://community.hubspot.com/t/extra-refine-filter-conditions-rolling-date-range/26693/8 "2024-11-04T11:15:42Z")
I am wanting to have a report run between the 8th and 7th of the next month. But I then want this to roll on every month?