id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
25240	"Add ""week"" lookup to DateField/DateTimeField"	Chris Foresman	Mads Jensen	"Per the recommendation [https://docs.djangoproject.com/en/1.8/ref/models/querysets/#extra here], filling a ticket requesting that a ""give me all items for the current week"" option be added to the ORM to filter `DateTime` fields. I'm using the following extra `WHERE` clause to achieve this:

{{{#!python
where=['EXTRACT(WEEK FROM timestamp) = EXTRACT(WEEK FROM CURRENT_TIMESTAMP)'])
}}}"	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	QuerySet.extra	tarkatronic@… borfast@… josh.smeaton@… code+django@…	Ready for checkin	1	0	0	0	0	0