# Rolling Date for dashboard reports **URL:** \ **Category:** HubSpot Ideas\ **Tags:** reports\ **Created:** [July 6, 2020, 2:18am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470 "2020-07-06T02:18:12Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Brina](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/brina/32/99730_2.png) [@Brina](https://community.hubspot.com/u/Brina)\ **Post date:** [July 6, 2020, 2:18am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/1 "2020-07-06T02:18:12Z")
Hi, It would be great if the rolling date range allows for data of current day to be shown as well instead of the past xx days. ---
**Author:** ![TerryB](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/terryb/32/86357_2.png) [@TerryB](https://community.hubspot.com/u/TerryB)\ **Post date:** [September 8, 2020, 1:19pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/2 "2020-09-08T13:19:15Z")
I fully agree with Brina, we need a rolling date range to include today too. Our team who use the dashboard will own be able to follow up on contacts who do a certain action today, tomorrow. ---
**Author:** ![adamgor](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamgor/32/9373_2.png) [@adamgor](https://community.hubspot.com/u/adamgor)\ **Post date:** [October 29, 2020, 9:57am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/3 "2020-10-29T09:57:24Z")
Yes! We need something of a filter for: Date is before xx days. ---
**Author:** ![RSullivan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rsullivan/32/21752_2.png) [@RSullivan](https://community.hubspot.com/u/RSullivan)\ **Post date:** [December 17, 2020, 4:11am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/4 "2020-12-17T04:11:12Z")
I’m new to Hubspot and am loving it compared to Salesfore! I have finished importing/scrubbing my data and have been setting up Reports and Dashboards and have encountered this issue and see it as the first serious defect with Hubspot. Dashboard reports are important for management/executives, and not having “Today” included in the Dashboard Reports when you use a “Rolling Date Range” filter basically means that all of today’s changes don’t roll up and display until the midnight of that day. I would think this would be an obvious design spec. I’m having trouble comprehending a business use case where by anyone would want a “Rolling Date Range” data filter to exclude the current day. Unless there’s a legitimate reason for this design choice, I’d consider this a bug 🐛 ---
**Author:** ![HubSpotMaster](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hubspotmaster/32/31853_2.png) [@HubSpotMaster](https://community.hubspot.com/u/HubSpotMaster)\ **Post date:** [March 11, 2021, 4:39pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/5 "2021-03-11T16:39:10Z")
This would be useful, it is not practical to have to update dates using the **Before** or **After** a specific date. This creates a reporting nightmare and daily task to update all reports. Examples of reports trying to create: - Last activity is greater than XX # of days ago Are there any updates on this basic reporting functionality? ---
**Author:** ![TJohnson3](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tjohnson3/32/18373_2.png) [@TJohnson3](https://community.hubspot.com/u/TJohnson3)\ **Post date:** [May 12, 2021, 9:07pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/6 "2021-05-12T21:07:16Z")
Hi Hubspot Team! Is there any update on the status of this reporting function? Without the ability to view today’s values in a “rolling X days” date range makes reporting inaccurate and is time consuming to consistently update date ranges, as previous users have mentioned, or toggle between “rolling X days” & “today” to get real values. ---
**Author:** ![jbuck](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jbuck/32/25270_2.png) [@jbuck](https://community.hubspot.com/u/jbuck)\ **Post date:** [July 13, 2021, 10:39pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/7 "2021-07-13T22:39:24Z")
I’m surprised this isn’t a thing already ---
**Author:** ![AMine0](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/amine0/32/26012_2.png) [@AMine0](https://community.hubspot.com/u/AMine0)\ **Post date:** [August 10, 2021, 11:52am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/8 "2021-08-10T11:52:36Z")
Hi Hubspot team! Any update on this feature ? Thanks ---
**Author:** ![JOakley](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joakley/32/39641_2.png) [@JOakley](https://community.hubspot.com/u/JOakley)\ **Post date:** [September 1, 2021, 5:49am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/9 "2021-09-01T05:49:07Z")
Hi, Also in desperate need of a rolling, dynamic date range for report. Wanting to display all clients who have not been contacted in the last 6 months for a monthly KPI report. Currently using “Last Contacted” and changing the date manually each month, would prefer if it could do it automatically. Function is there for 30/60/90 days, can we add 180 days please? ---
**Author:** ![jaygoldman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaygoldman/32/100273_2.png) [@jaygoldman](https://community.hubspot.com/u/jaygoldman)\ **Post date:** [May 3, 2022, 3:53pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/10 "2022-05-03T15:53:15Z")
Like others in this thread, I’m looking to build a report that highlights Contacts who have not had activity in the last 7 days. I did find a resolution to this problem, though it’s a fair bit of extra work. It would be much easier to add Report options for Contacts and Companies that match the date filters available for Deals, which do have a rolling date: ![Screen Shot 2022-05-03 at 2.59.22 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/0/207717a1b295bf01770f41ed9f3c8b749992d131.png) Right now this doesn’t seem possible given the filter options. You can filter on Last Activity Date being in the last 14 days (the opposite of what I want) using the IS filter: ![Screen Shot 2022-05-03 at 11.50.41 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/b/8ba345fe6ab6a8b4c8c0a4b1a373ab298ed73cdc.png) Is filter There’s unfortunately no “is not” equivalent that would invert those selections (i.e.: Last Activity Date is not in the last 14 days). The Before option requires a hard coded date, which doesn’t give an option for a rolling window: ![Screen Shot 2022-05-03 at 11.50.56 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/f/fcbd9c451a69c9b0dd9647b021c28bf86eae061f.png) Is before filter The challenge could also be solved by having that filter be a drop-down of options (i.e.: Last Activity Date is before 14 days) with a “Custom date” option. The resolution for now appears to be: 1. Add a new Property to your Contact records. I called mine _Aging_ and made it a Yes/No Checkbox. 2. Create a new Workflow. Set the Trigger to _Last Activity Date_ on Contacts is \> x days. Add a single action to Set Property Value of _Aging_ to Yes. 3. Create a second new Workflow. Set the Trigger to _Last Activity Date_ on Contacts is \< x days. Add a single action to Set Property Value of _Aging_ to No. At this point all of your Contacts should have the right value in _Aging._ You can now include that in your Reports and you should have the right records show up. ---
**Author:** ![jaygoldman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaygoldman/32/100273_2.png) [@jaygoldman](https://community.hubspot.com/u/jaygoldman)\ **Post date:** [May 3, 2022, 10:53pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/11 "2022-05-03T22:53:35Z")
An alternate approach that also works if you have Lists in your subscription: - Make a new List - Set the List criteria to Last Activity Date is before x days ago - Create a Report on Contacts with the filter on List Membership field set to your new List ---
**Author:** ![CBN](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cbn/32/95196_2.png) [@CBN](https://community.hubspot.com/u/CBN)\ **Post date:** [November 30, 2022, 10:27pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/12 "2022-11-30T22:27:28Z")
I fully support this feature. As an experienced software developer, analytics and reporting analyst Today() or Now() are one of the most important things in your reports and dashboards. How HubSpot has not implemented this is really completely beyond my imagination to understand. That Now() is 5 or 10 minutes old due to performance, timing etc. is fine for almost all uses in HubSpot, but not that you cannot pull as dashboard with a rolling range as from now and 7 or 14 days back in history. @Brina - any links to someone at HubSpot who cares about this important GAP in the application? ---
**Author:** ![TDriessen](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/tdriessen/32/92529_2.png) [@TDriessen](https://community.hubspot.com/u/TDriessen)\ **Post date:** [February 20, 2024, 8:53am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/13 "2024-02-20T08:53:22Z")
Is there any update on this subject? Maybe another post about the same subject where Hubspot has confirmed it is on the roadmap? ---
**Author:** ![CBN](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cbn/32/95196_2.png) [@CBN](https://community.hubspot.com/u/CBN)\ **Post date:** [February 20, 2024, 6:07pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/14 "2024-02-20T18:07:45Z")
Don’t hold your breath @TDriessen HubSpot does not make anything public here and makes sure not to read anything we write… At least that is my conclusion after trying for many years. ---
**Author:** ![saynuk](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@saynuk](https://community.hubspot.com/u/saynuk)\ **Post date:** [April 19, 2024, 2:09pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/15 "2024-04-19T14:09:13Z")
I can’t believe this bug has been present for at least 4 years now, and never been corrected/improved. ---
**Author:** ![CBN](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/cbn/32/95196_2.png) [@CBN](https://community.hubspot.com/u/CBN)\ **Post date:** [April 19, 2024, 2:14pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/16 "2024-04-19T14:14:38Z")
My words exactly @saynuk for this and many similar bugs and gaps that we at [uQualio](https://uqualio.com) have run into during our years with HubSpot. And this is part of why we are seriously considering leaving HubSpot. Too many things and nothing happening like you see here. ---
**Author:** ![Vytautas\_SNP](https://avatars.discourse-cdn.com/v4/letter/v/838e76/32.png) [@Vytautas\_SNP](https://community.hubspot.com/u/Vytautas_SNP)\ **Post date:** [June 7, 2024, 7:09am UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/17 "2024-06-07T07:09:29Z")
unbelievable how much we should wait to get it ---
**Author:** ![EMistDMC](https://avatars.discourse-cdn.com/v4/letter/e/9d8465/32.png) [@EMistDMC](https://community.hubspot.com/u/EMistDMC)\ **Post date:** [August 7, 2024, 8:48pm UTC](https://community.hubspot.com/t/rolling-date-for-dashboard-reports/22470/18 "2024-08-07T20:48:03Z")
We need this!!!