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
17831	"Admin's date list filter's ""This month/year"" and ""Today"" are incorrect when USE_TZ is set (with the postgres backend)."	Glenn Washburn <development@…>	nobody	"This may be applicable to other backends, but I'm not sure.

When using USE_TZ the backend connection is set to use UTC.  So __year/__month/__day lookup filters will filter where the UTC timestamp has a year/month/day of the lookup value.  However, what's really desired is to use the timestamp at the current timezone.  For example, the current code when filtering for ""today"" datetimes which are not in UTC can potentially return a list of matching records where the set of days being displayed is more than one.
"	Bug	new	contrib.admin	1.4-beta-1	Normal				Unreviewed	0	0	0	0	0	0