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