CODEWITHSUNDEEP
pythondjango
Jeff Taggarty
Jeff Taggarty

Reputation: 1471

Select between two dates with Django

I am looking to make a query that selects between dates with Django.

I know how to do this with raw SQL pretty easily, but how could this be achieved using the Django ORM?

This is where I want to add the between dates of 30 days in my query:

start_date = datetime.datetime.now() + datetime.timedelta(-30)
context[self.varname] = self.model._default_manager.filter(
    current_issue__isnull=True
    ).live().order_by('-created_at')

Upvotes: 146

Views: 103572

Answers (4)

suhailvs
suhailvs

Reputation: 21680

If you are using a DateTimeField, Filtering with dates won’t include items on the last day.

You need to casts the value as date:

...filter(created_at__date__range=(start_date, end_date))

Upvotes: 7

Daniel Roseman
Daniel Roseman

Reputation: 599450

Use the __range operator:

...filter(current_issue__isnull=True, created_at__range=(start_date, end_date))

Upvotes: 290

Manjuanth V M
Manjuanth V M

Reputation: 137

two methods

.filter(created_at__range=[from_date, to_date])

another method

.filter(Q(created_at__gte=from_date)&Q(created_at__lte=to_date))
  • gte means greater than equal
  • lte means less than equal

Upvotes: 3

Ignacio Vazquez-Abrams
Ignacio Vazquez-Abrams

Reputation: 798456

__range

Upvotes: 26

Related Questions