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

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)





12 Replies
New Contributor



We need exactly the same feature. To be able to see results including "today" in the "last X days" filter.

New Member



Same on my side, the feature is needed to improve working with HubSpot.

Regular Contributor | Platinum Partner

Our team would find this feature really useful too.


We'd also like to be able to select a filter such as deal closing date "is before today" as an option rather than having to manually select and update the date every day.

Occasional Contributor

Agree with the above. It would be great to have these filters in the list filters too e.g. contacts/deals lists and not only in the report filters

Regular Contributor

This is critical to making sure we are operating our business in real time and not a day late.

Regular Contributor

Yes, please. 


We have dashboards with activities for our reps and at the end of the day we want to see activity for the week so far. but if you have a dashboard / report filtered on "last 7 days" - today is excluded. It's rather unituitive that it's excluding today. 

New Member

+1 Would be a great addition.

New Contributor

Yes please, we need that.

New Member

This is a really basic functionality, I can honestly say that I'm suprised that this has not been resolved yet.

Occasional Contributor

+1 for this functionality. I am trying to build a saved filter for my team that shows them contacts assigned to them in the "Last 7 days." I'd prefer that include today, but there's no way to do that.


The work-around to use "This Week" or "This Month" isn't preferrable because that filter is very short when we're at the start of the week or month.


Honestly, what I'd really prefer is for there to just be a "Custom" filter option where I can drop in custom boolean logic and relative dates like what is possible in Salesforce's reporting.

Status updated to: In Planning
HubSpot Product Team


In standard reporting, give me an OR option at least: Last 30 Days (excluding today) or Today


Using the API and Service tooling HS offers, we're trying to keep track of Contacts who load pages within our SaaS platform by setting a customer Contact Property (Date Last Seen) as today's date. This way, we can report back MAUs by looking at Date Last Seen less than 31 days ago.