# Date Filter Monday to Sunday Week

**URL:** <https://forums.knack.com/t/date-filter-monday-to-sunday-week/15906>\
**Category:** API & Custom Code\
**Created:** [March 24, 2024, 12:58pm UTC](https://forums.knack.com/t/date-filter-monday-to-sunday-week/15906 "2024-03-24T12:58:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Angie](https://avatars.discourse-cdn.com/v4/letter/a/ec9cab/32.png) [@Angie](https://forums.knack.com/u/Angie)\
**Post date:** [March 24, 2024, 12:58pm UTC](https://forums.knack.com/t/date-filter-monday-to-sunday-week/15906/1 "2024-03-24T12:58:22Z")

</div>

I have seen many requests about the date filter for current week using Sunday - Saturday and many users needing the week to be Monday - Saturday. This one issue is messing up my entire project. I understand Knack provides an option for Calendar views but that is not what I am looking for. I have pivot tables and grids that I need filtered by work week which is Monday - Saturday. Does anyone have a workaround or solution for this? This is needed asap and I cannot figure out what to do.

---

<div class="post-metadata">

**Author:** ![RakeshBajania](https://avatars.discourse-cdn.com/v4/letter/r/d9b06d/32.png) [@RakeshBajania](https://forums.knack.com/u/RakeshBajania)\
**Post date:** [June 28, 2024, 3:03pm UTC](https://forums.knack.com/t/date-filter-monday-to-sunday-week/15906/2 "2024-06-28T15:03:34Z")

</div>

Hello,

I can develop this feature using custom JavaScript for you.

Feel free to reach out to me at [rakesh.bajania@gmail.com](mailto:rakesh.bajania@gmail.com) if you’re interested.

Thanks!

---

<div class="post-metadata">

**Author:** ![Dean2](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@Dean2](https://forums.knack.com/u/Dean2)\
**Post date:** [June 29, 2024, 2:14am UTC](https://forums.knack.com/t/date-filter-monday-to-sunday-week/15906/3 "2024-06-29T02:14:39Z")

</div>

Angie

You could possibly use an Equation field using the function getDateWeek. If you have any records on a Sunday that you wish to exclude for any reason, then you could use the function getDateDayOfWeek.

Dean
