Last X days up to yesterday VS. last X days up to today

[VagaeNatus]

Currently, filters involving rules like "last X days", excludes today. We need a second version of that filter that includes today.

Use case: I want to track the activity of my Sales Reps, I build a report and I want to see how is the activity over 30 days including today: currently, I can't. I can either show "last 30 days" (in which case I will not see today) or "this month" (in which case as the beginning of each month I will not see how we were doing the week before).

Example: Adwords (an many other systems) has those 2 options (see below)

There were some conversations on the forum on how to achieve what this feature would do (see here)

[CatherinWright]

+1, please add an option to filter and report on records based on last X days including today. This is a critical functionality. I was shocked to learn about this limitation in HubSpot.

[JonnyPrice]

Yes -- please please please build this feature! Need more flexibility in which dates to show -- either "within a fixed date range", or "between X days before today, and Y days before today" (where Y will frequently be zero). Thanks!!!

[EKoomen]

+1. It goes against all logic for running a business in real-time. Please add.

This thread was started in Feb 2019, the planning started in April 2020, and it is almost 2023.

[EPenne]

Hi, Hubspot! 2022 is calling! Come on, pick up!
It can't be that you are working on this. Do you need developers, we can help.
Let us at least be able to have an OR function in filters that allow us to show results with both last 14 days OR Today. 

[djkgamc]

I'm always shocked, I would expect this kind of unacceptable oversight from a company building an MVP about 2 weeks into the product, and only them

[AeroBlock]

Wow June 2022!

When I joined Hubspot during its beta it was issues like this that stopped me from converting. How is this still not resolved! So basic and fundamental!!! What's going on guys! 2022!!!! You are embarrasing yourselves

[jmbray]

+1

[RKlunk]

+1

[Luxeworld]

Just adopted Hubspot and cannot believe this is an issue... My staff are confused... Seems so obvious requirement. Any update by Hubspot?

[MLiberato]

Hi Team! Any update on this Idea? it would be really useful to get this done 🙂 

[SPollock]

Honestly, I don't even understand the use case of "not including today".  I can't imagine a scenario where I'd want that!  If anything the default would be include today (semantically, it just makes sense - completed within the last N days of course includes today).  And if someone really wants to "exclude today", then have a checkbox or something.  Current implementation is not a correct English (or math) semantic.

[FvanderPijl]

+1

[metric_mission]

+1; this should've already been done there are so many threads asking for this.