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
30922	Admin's date_hierarchy excludes 31 october when using timezone with DST in northern hemisphere.	Erwin Junge	Erwin Junge	https://code.djangoproject.com/ticket/28933 introduced a subtle bug where it accidentally excludes 31 october in the admin date_hierarchy filter after selecting october. The underlying reason is that the generated sql has `< 2019-10-31` as opposed to `< 2019-11-01` as it should be. This in turn is caused by applying the timezone for 2019-10-01 (with DST in countries in the northern hemisphere) to the date used for 2019-11-01. This causes the date conversion to actually operate on 2019-10-31 23:00 instead of 2019-11-01 00:00. It's a bit hard to explain in words, PR incoming that hopefully explains better in code.	Bug	closed	contrib.admin	dev	Normal	fixed	date_hierarchy		Ready for checkin	1	0	0	0	0	0