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-2020 and 31-Jan-2020?

Answer 1

Hello @kartik,

Use

Sample.objects.filter(date__range=["2020-01-01", "2020-01-31"])

Or if you are just trying to filter month wise:

Sample.objects.filter(date__year='2020', 
                      date__month='01')

Hope it helps!!

Thank You!!