# Add to date filter: Last Complete (Week, Month, Year)

**URL:** <https://community.holistics.io/t/add-to-date-filter-last-complete-week-month-year/1579>\
**Category:** Feature Suggestions\
**Tags:** dashboard, filters\
**Created:** [July 3, 2023, 11:42am UTC](https://community.holistics.io/t/add-to-date-filter-last-complete-week-month-year/1579 "2023-07-03T11:42:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robin\_Kanerva](https://community.holistics.io/user_avatar/community.holistics.io/robin_kanerva/32/1262_2.png) [@Robin\_Kanerva](https://community.holistics.io/u/Robin_Kanerva)\
**Post date:** [July 3, 2023, 11:42am UTC](https://community.holistics.io/t/add-to-date-filter-last-complete-week-month-year/1579/1 "2023-07-03T11:42:35Z")

</div>

Hi, something that was useful with Looker was to be able to filter on date with Last Complete Week, Month, Year. This way it’s easy to build dash board that always have the correct data within it.

---

<div class="post-metadata">

**Author:** ![Theodore](https://community.holistics.io/user_avatar/community.holistics.io/theodore/32/832_2.png) [@Theodore](https://community.holistics.io/u/Theodore)\
**Post date:** [July 5, 2023, 9:23am UTC](https://community.holistics.io/t/add-to-date-filter-last-complete-week-month-year/1579/2 "2023-07-05T09:23:40Z")

</div>

Hi @Robin_Kanerva,

Welcome to the community 🎉

If I understand correctly, you would like the filter to only include complete time units such as weeks, months, or years, while excluding incomplete periods.

The current behavior of Holistics filters aligns with this requirement. For example, when you filter for `last 3 months`, by default, if today is June 15th, you will receive data for March, April, May, and **no data for June**. We also offer the option **‘Up to now / Up to today’** to include the incomplete period.

For more detailed information, please refer to our documentation on this topic: [Date Filters | Holistics Docs](https://docs.holistics.io/docs/filters/date-filters#1-the-filtering-time-period-defaults-to-be-a-complete-periodaccording-to-the-time-unit)

Hope this helps!
