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
10911	Date comparison lookup operators	vbmendes	Clément Nodet	"It would be nice to have lookup operators such as {{{ day_gt }}}, {{{ day_gte }}}, {{{ day_lt }}}, {{{ day_lte }}}, {{{ month_gt }}}, {{{ month_gte }}}, {{{ month_lt }}} and {{{ month_lte }}}. With this, we will be able to do comparisons such as {{{ date__month_gt=6 }}} to find objects with the date object in the second semester, and much more good things. The lookups are:

 * {{{ day_lt }}} -- day lower then;
 * {{{ day_gt }}} -- day greather then;
 * {{{ day_lte }}} -- day lower then or equal;
 * {{{ day_gte }}} -- day greather then or equal;
 * {{{ day_range }}} -- accepts a tuple or list with two elements, just like the range loopup operator;

And the same thing for month, year and week_day.

"	New feature	closed	Database layer (models, ORM)	1.0	Normal	wontfix	lookup, orm, date		Accepted	0	0	0	0	0	0