# Custom Rolling Date Range **URL:** \ **Category:** Dashboards & Reporting\ **Created:** [November 24, 2017, 1:11pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994 "2017-11-24T13:11:40Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Ying](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ying/32/38114_2.png) [@Ying](https://community.hubspot.com/u/Ying)\ **Post date:** [November 24, 2017, 1:11pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/1 "2017-11-24T13:11:40Z")
I’m trying to create a dashboard that will show me deals in progress on a rolling ‘close dates’ 3 month/90 period - has anyone created anything that might be suitable for this? I know there’s the one month/this quarter style but nothing I can adjust myself, so looking for ideas how I can workaround this. Many thanks! ---
**Author:** ![Phil\_Vallender](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phil_vallender/32/48924_2.png) [@Phil\_Vallender](https://community.hubspot.com/u/Phil_Vallender)\ **Post date:** [November 25, 2017, 11:49pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/2 "2017-11-25T23:49:54Z")
Hi @Ying Do you have the reporting add on? If so, it looks like you can create a dashboard report with a date range set to a rolling date of the last 90 days. Does that help you do want you want to do? ---
**Author:** ![Ying](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ying/32/38114_2.png) [@Ying](https://community.hubspot.com/u/Ying)\ **Post date:** [November 27, 2017, 9:29am UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/3 "2017-11-27T09:29:48Z")
Hi Phil, Thanks for getting back to me - it’s the next 90 days that we are looking to report for. For example, what deals are due to close in the next 90 days, the stage they’re in and the value. Kindest regards, Ying ---
**Author:** ![joshl](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joshl/32/87988_2.png) [@joshl](https://community.hubspot.com/u/joshl)\ **Post date:** [December 14, 2017, 5:03pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/4 "2017-12-14T17:03:09Z")
I too am looking for a way to create a rolling forecast of deals in the next year. Unfortunately the Deal “Forecast” report only supports a past-period rolling option. ---
**Author:** ![ParkerShort](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/parkershort/32/62242_2.png) [@ParkerShort](https://community.hubspot.com/u/ParkerShort)\ **Post date:** [May 31, 2018, 2:20am UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/5 "2018-05-31T02:20:56Z")
Let me add that this is a good idea to implement. You get next month and next quarter, but only rolling date ranges for the past. I’d love to be able to set up a rolling date range for the future - e.g. show me deals that are closing in the next 90 days. ---
**Author:** ![Ying](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ying/32/38114_2.png) [@Ying](https://community.hubspot.com/u/Ying)\ **Post date:** [May 31, 2018, 9:04am UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/6 "2018-05-31T09:04:42Z")
Thanks @ParkerShort - it baffles me why it isn’t already a standard feature! ---
**Author:** ![karinamariotti](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karinamariotti/32/42198_2.png) [@karinamariotti](https://community.hubspot.com/u/karinamariotti)\ **Post date:** [November 2, 2018, 7:01pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/7 "2018-11-02T19:01:10Z")
This isn’t really a solution to the problem explained here. What is needed is the option to set a rolling date to future dates. Right now the only options are like “Last 7 days” when we also need “Next 7 days”. Commenting to hopefully bring more attention to this pretty important reporting functionality. ---
**Author:** ![RICWAH](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/ricwah/32/2490_2.png) [@RICWAH](https://community.hubspot.com/u/RICWAH)\ **Post date:** [December 23, 2019, 11:26am UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/8 "2019-12-23T11:26:58Z")
I have the same need. Hubspot is very focused on what already have happened. But many times you want to see what is going to happen (forecasting). That’s why a rolling date range for the NEXT 30/60/90 days are important. ---
**Author:** ![PaulMF](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/paulmf/32/99678_2.png) [@PaulMF](https://community.hubspot.com/u/PaulMF)\ **Post date:** [August 28, 2019, 4:13pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/9 "2019-08-28T16:13:54Z")
Hi, major thread bump here - but I still cannot see a forward looking rolling date range? ---
**Author:** ![astrong](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/astrong/32/9140_2.png) [@astrong](https://community.hubspot.com/u/astrong)\ **Post date:** [December 9, 2019, 8:24pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/10 "2019-12-09T20:24:23Z")
We are also in need of a rolling date in the future feature. e.g. “Deals set to close in the next 90 days” ---
**Author:** ![BastiSchuhl](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bastischuhl/32/42145_2.png) [@BastiSchuhl](https://community.hubspot.com/u/BastiSchuhl)\ **Post date:** [January 16, 2020, 4:15pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/11 "2020-01-16T16:15:05Z")
Future rolling time frames are certainly needed; @ All, please upvote this “idea submitted” to rais more awareness for this topic: [https://community.hubspot.com/t5/HubSpot-Ideas/Future-Rolling-Date-Range/idi-p/214836](https://community.hubspot.com/t5/HubSpot-Ideas/Future-Rolling-Date-Range/idi-p/214836) Thanks! ---
**Author:** ![acjandler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/acjandler/32/68963_2.png) [@acjandler](https://community.hubspot.com/u/acjandler)\ **Post date:** [December 3, 2021, 5:32pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/12 "2021-12-03T17:32:02Z")
Looks like this has been an active request since 2017… is there any update on this? Any plan to include it? (Buehler? Buehler?) ---
**Author:** ![BCapewell](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bcapewell/32/75391_2.png) [@BCapewell](https://community.hubspot.com/u/BCapewell)\ **Post date:** [March 29, 2022, 4:42pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/13 "2022-03-29T16:42:39Z")
Would also love to see this as a feature. I would like to look at the last 7 days, 7 days before, and the 7 days before that on a company scorecard dash. Just displaying a simple number to give a general understanding of progress to the whole company. Currently, I have to manually adjust this before each weekly meeting. ---
**Author:** ![kit-lyman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kit-lyman/32/11119_2.png) [@kit-lyman](https://community.hubspot.com/u/kit-lyman)\ **Post date:** [April 29, 2022, 7:35pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/14 "2022-04-29T19:35:26Z")
Hi Everyone! As always, thanks for sharing your thoughts and feedback. I am the product manager for the custom report builder, and I have good news—we are working on adding a custom rolling date option for “last” and “next” periods! These custom period options will first be added to the [new date range comparisons functionality](https://knowledge.hubspot.com/reports/compare-date-ranges-in-the-custom-report-builder), which is currently in a public beta. Alongside the update in the custom report builder, we are working with the filters team to have this added as a standard option overall. [Here is the Community idea](https://community.hubspot.com/t5/HubSpot-Ideas/Future-Rolling-Date-Range/idi-p/214836) currently tracking this work. Please let me know if you have any thoughts or questions, and certainly keep the feedback coming! Best, Kit ---
**Author:** ![kvlschaefer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kvlschaefer/32/71076_2.png) [@kvlschaefer](https://community.hubspot.com/u/kvlschaefer)\ **Post date:** [April 29, 2022, 8:22pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/15 "2022-04-29T20:22:22Z")
Hi @kit-lyman, This is great news! Thanks for sharing this update with us 🙂 Best, Kristen ---
**Author:** ![SafetyChainCRO](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/safetychaincro/32/64675_2.png) [@SafetyChainCRO](https://community.hubspot.com/u/SafetyChainCRO)\ **Post date:** [November 3, 2022, 7:07pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/16 "2022-11-03T19:07:14Z")
Hi @kit-lyman Can you reshare the link to the Community Idea for this - it dead-ends for me. It looks like the custom report-builder option was added in August (nice). We’d like to use on boards / forecasting where the default options don’t support a rolling 6mos view, which we need. Any advice on when this may make it into the broader filters team options? ---
**Author:** ![kit-lyman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/kit-lyman/32/11119_2.png) [@kit-lyman](https://community.hubspot.com/u/kit-lyman)\ **Post date:** [November 16, 2022, 5:05pm UTC](https://community.hubspot.com/t/custom-rolling-date-range/3994/17 "2022-11-16T17:05:41Z")
My apologies on the misfire on that link, @SafetyChainCRO! I’ve updated my original post with the correct link. Support for custom rolling date ranges on filters at large is something the team is working on now, with hopeful targets being in the first half of next year for implementation. For now, I’d recommend using the “days from now” option when doing future-looking filters within Lists, which can then be used as a “List Membership” filter on Contacts and Company index pages. ![Rolling date option in Lists.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/0/d/0d5f1bde0ef2f4710f6a57abb242c12762389b16.png)