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)
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.
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.
+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.
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.
I'm amazed this isn't how this filter works already - ask any rep, or anyone running a team or leading ops if they want to see data from today included in your rolling "last x days" report and not a single person will say no. This is a no-brainer in how a rolling date range filter should function.
In general, the date filters available are inconsistenct across single vs custom reporting, lists, and workflows. It would be great if all date filter options were available across all functions, and if there was a clearer sense of what "Rolling Dates" means vs "Less than X days Ago" etc. Also, the fact that the backend uses a datetime feature while the date picker in the front end does not, really throws things off the "Less than X days ago" date filter.