# How to find end of week between 2 dates

**URL:** <https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429>\
**Category:** Toad for IBM DB2\
**Created:** [January 14, 2025, 12:50am UTC](https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429 "2025-01-14T00:50:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ipeleva](https://avatars.discourse-cdn.com/v4/letter/i/ce73a5/32.png) [@ipeleva](https://forums.toadworld.com/u/ipeleva)\
**Post date:** [January 14, 2025, 12:50am UTC](https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429/1 "2025-01-14T00:50:51Z")

</div>

I need help please . How to find all end of weeks between 2 dates ( start date 20230101 and end date 20250131)  
end of weeks : 20230107, 20230114, 20230121 etc

Thank you

---

<div class="post-metadata">

**Author:** ![Gita.Sharifi](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gita.sharifi/32/16973_2.png) [@Gita.Sharifi](https://forums.toadworld.com/u/Gita.Sharifi)\
**Post date:** [January 14, 2025, 5:47pm UTC](https://forums.toadworld.com/t/how-to-find-end-of-week-between-2-dates/60429/2 "2025-01-14T17:47:58Z")

</div>

Hi, have you tried [DAYOFWEEK](https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-dayofweek) or [DAYOFWEEK\_ISO](https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-dayofweek-iso) functions?