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?