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 12489 Need a Field Lookup for day of year: __dayofyear Dean Quinanola v1v3kn The current built-in year, month, day, week_day Field Lookups do not directly help if you need to find rows that are on a specific date. In SQL, there is a DAYOFYEAR(). It would be useful to have a Field Lookup that pairs this function with python datetime's %j directive New feature closed Database layer (models, ORM) Normal fixed field lookup datetime filter Accepted 1 1 0 0 0 0