How do I filter query objects by date range in Django

Question

I ve got a field in one model like   class Sample models Model       date   fields DateField auto now False    Now  I need to filter the objects by a date range   How do I filter all the objects that have a date between 1-Jan-2011 and 31-Jan-2011

User · Answer

To make it more flexible  you can design a FilterBackend as below   class AnalyticsFilterBackend generic filters BaseFilterBackend       def filter queryset self  request  queryset  view           predicate   request query params   or request data for POST          if predicate get  from date   None  is not None and predicate get  to date   None  is not None              queryset   queryset filter your date  range  predicate  from date    predicate  to date              if predicate get  from date   None  is not None and predicate get  to date   None  is None              queryset   queryset filter your date  gte predicate  from date             if predicate get  to date   None  is not None and predicate get  from date   None  is None              queryset   queryset filter your date  lte predicate  to date            return queryset

User · Answer

you can use  quot   range quot  for example   from datetime import datetime start date datetime 2009  12  30  end end datetime 2020 12 30  Sample objects filter date  range  start date end date

User · Answer

Use   Sample objects filter date  range   2011-01-01    2011-01-31      Or if you are just trying to filter month wise    Sample objects filter date  year  2011                          date  month  01     Edit  As Bernhard Vallant said  if you want a queryset which excludes the specified range ends you should consider his solution  which utilizes gt lt  greater-than less-than

User · Answer

Is simple    YourModel objects filter YOUR DATE FIELD  date timezone now      Works for me

User · Answer

You can use django s filter with datetime date objects   import datetime samples   Sample objects filter sampledate  gte datetime date 2011  1  1                                   sampledate  lte datetime date 2011  1  31

User · Answer

When doing django ranges with a filter make sure you know the difference between using a date object vs a datetime object    range is inclusive on dates but if you use a datetime object for the end date it will not include the entries for that day if the time is not set       startdate   date today       enddate   startdate   timedelta days 6      Sample objects filter date  range  startdate  enddate     returns all entries from startdate to enddate including entries on those dates  Bad example since this is returning entries a week into the future  but you get the drift       startdate   datetime today       enddate   startdate   timedelta days 6      Sample objects filter date  range  startdate  enddate     will be missing 24 hours worth of entries depending on what the time for the date fields is set to

User · Answer

Still relevant today  You can also do   import dateutil import pytz  date   dateutil parser parse  02 11 2019   replace tzinfo pytz UTC

User · Answer

You can get around the  impedance mismatch  caused by the lack of precision in the DateTimeField date object comparison -- that can occur if using range -- by using a datetime timedelta to add a day to last date in the range  This works like   start   date 2012  12  11  end   date 2012  12  18  new end   end   datetime timedelta days 1   ExampleModel objects filter some datetime field  range  start  new end     As discussed previously  without doing something like this  records are ignored on the last day   Edited to avoid the use of datetime combine -- seems more logical to stick with date instances when comparing against a DateTimeField  instead of messing about with throwaway  and confusing  datetime objects  See further explanation in comments below

[python] How do I filter query objects by date range in Django?

Examples related to python

Examples related to django

Examples related to django-models

Examples related to django-queryset