Select between two dates with Django

Question

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

suhailvs · Accepted Answer · 2020-03-03 04:18:02Z

291

Use the __range operator:

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

edited Mar 3, 2020 at 4:18

suhailvs

21.9k15 gold badges104 silver badges104 bronze badges

answered Oct 18, 2010 at 20:46

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bigbob556677 Over a year ago

Is the "created_at" an arbitrary field in a model or is this the databases actual log of when the record was created?

Benbb96 Over a year ago

@Philip556677 It's an arbitrary field in a model. You can set the DateField's auto_now_add parameter to True in order to have it easily.

Ignacio Vazquez-Abrams · Accepted Answer · 2010-10-18 20:45:14Z

26

__range

answered Oct 18, 2010 at 20:45

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Comments

suhailvs · Accepted Answer · 2020-03-03 05:27:33Z

7

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

answered Mar 3, 2020 at 5:27

suhailvs

21.9k15 gold badges104 silver badges104 bronze badges

Comments

Manjuanth V M · Accepted Answer · 2020-02-07 18:30:16Z

3

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

answered Feb 7, 2020 at 18:30

Manjuanth V M

1372 silver badges10 bronze badges

1 Comment

Carmoreno Over a year ago

Q Objects is unnecessary in the second method, you can write: .filter(created_at__gte=from_date, created_at__lte=to_date)

Collectives™ on Stack Overflow

Select between two dates with Django

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related