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
6141	DateField __year queries don't return all records.	dougvanhorn@…	nobody	"When querying a !DateField using the !__year lookup type, the first day of the year, January 1, is not returned.

I can't speak to why the code is the way it is right now, but my patch changes the !__year lookups to be the same as the !__month and !__day lookups.  As quick background, !__year lookups are handled using 'between' in the where clause, versus an SQL function for !__month and !__day.

 * test.diff modifies the basic test case to highlight the error.
 * fix.diff fixes the bug.

All tests appear to run correctly against sqlite and postgresql."		closed	Database layer (models, ORM)	dev		duplicate	DateField __year query		Unreviewed	1	0	0	0	0	0