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

by

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).

More Related Contents:

  1. Django Aggregation: Summation of Multiplication of two fields
  2. How do I do a not equal in Django queryset filtering?
  3. Django values_list vs values
  4. “_set” in a queryset object in Django
  5. Count number of records by date in Django
  6. QuerySet, Object has no attribute id – Django
  7. Get the latest record with filter in Django
  8. Django filter JSONField list of dicts
  9. How to delete a record in Django models?
  10. Can a dictionary be passed to django models on create?
  11. Django dynamic model fields
  12. Programmatically saving image to Django ImageField
  13. How can I filter a date of a DateTimeField in Django?
  14. Django post_save() signal implementation
  15. What is the most efficient way to store a list in the Django models?
  16. difference between filter with multiple arguments and chain filter in django
  17. LEFT JOIN Django ORM
  18. django.db.migrations.exceptions.InconsistentMigrationHistory
  19. Django Blob Model Field
  20. Django Many-to-Many (m2m) Relation to same model
  21. How to combine multiple querysets in Django?
  22. How to change the file name of an uploaded file in Django?
  23. How to monkey patch Django?
  24. Easiest way to rename a model using Django/South?
  25. Simple Subquery with OuterRef
  26. Good ways to sort a queryset? – Django
  27. Resize fields in Django Admin
  28. python_2_unicode_compatible error
  29. How to properly use the “choices” field option in Django
  30. update django database to reflect changes in existing models

Leave a Comment