Unit 3 · Lesson 2 of 3 · 3.2 This week
Next: ORDER BY
- Concept
- Example
- Try it
- 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…