Skip to content

Unit 3 · Lesson 2 of 3 · 3.2 This week

Next: ORDER BY

  1. Concept
  2. Example
  3. Try it
  4. Check

Concept

startOfDay, startOfWeek, endOfWeek are calendar bounds in the site timezone. They are not rolling durations.

Worked sample

duedate >= startOfWeek() AND duedate <= endOfWeek()

Due this calendar week, including resolved work.

On the board: APP-34, APP-35, APP-40, APP-48…

Was this clear?