# Display records by Week Commencing

**URL:** <https://forums.knack.com/t/display-records-by-week-commencing/15219>\
**Category:** Ask Developers\
**Created:** [November 23, 2023, 12:24pm UTC](https://forums.knack.com/t/display-records-by-week-commencing/15219 "2023-11-23T12:24:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\
**Post date:** [November 23, 2023, 12:24pm UTC](https://forums.knack.com/t/display-records-by-week-commencing/15219/1 "2023-11-23T12:24:20Z")

</div>

I have tried to use the calendar view, but it doesn’t quite do what I need.

I would like to see clients down the left then in each week display the date that the client had Keywork a bit like this:

![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e1c4addac25daef9b77a35bd7ec23d8e12763d1a.png)

The closest I have come to is using the display as list in the calendar, but it will only display 1 week at a time and doesn’t show the clients who haven’t had a keywork that week. I know that I could have an object with each field as a week/commencing but I have not found a way to dynamically create fields also I feel that this would create a massive object in 5 years.

I am not even sure if this is possible.

Any help will be much appreciated.

Craig

---

<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:** [November 23, 2023, 8:30pm UTC](https://forums.knack.com/t/display-records-by-week-commencing/15219/2 "2023-11-23T20:30:29Z")

</div>

Hi Craig

I’d suggest a formula like you would in Excel to find the beginning of the week (Monday?): Date - WEEKDAY(Date,2)+1.

Dean

---

<div class="post-metadata">

**Author:** ![CSWinnall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/cswinnall/32/3631_2.png) [@CSWinnall](https://forums.knack.com/u/CSWinnall)\
**Post date:** [November 23, 2023, 8:31pm UTC](https://forums.knack.com/t/display-records-by-week-commencing/15219/3 "2023-11-23T20:31:36Z")

</div>

Thanks I’ll try that
