Django Queryset: filter by weeks

user3972986

I am trying to filter a query by weeks. It will return jobs if the jobs report_by_date is within a week.

Job.objects.filter((report_by_date-datetime.today()).days <= 7)

Alasdair

You can create a datetime for one week ago, then filter all jobs after that.

from datetime import datetime, timedelta
one_week_ago = datetime.today() - timedelta(days=7)
jobs = Job.objects.filter(report_by_date__gte=one_week_ago)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-10-23

Comments

0 comments

Django, queryset, filter today

DJango filter_queryset

django QuerySet filter()

Reuse filter() queryset in Django

Django template filter queryset

Django Filter Queryset Model

Queryset filter() in Django with ForeignKey

django queryset filter foreignkey

Django - Count and filter in queryset

Django get a queryset and filter by own queryset item

Django Queryset filter for ForeignKey elements

Is it possible to filter foreignkeys with a queryset? Django

Django: Filter queryset by property of Element

Django queryset filter for blank FileField?

django multiple filter options on queryset

Django: Queryset filter with multilevel nesting

django form filter field queryset

Django QuerySet filter ValueError not caught?

Filter Django ResourceRelatedField's queryset

Django filter queryset if a field exists

Django queryset filter filefield not empty

Django queryset filter - Q() | VS __in

Django QuerySet filter over string

Filter Django queryset for a dict value

Django filter queryset for replacing charactors

Filter Django queryset with multiple variables

Django queryset- Filter by not in list

Django: filter queryset by multiple ID

How to filter queryset not equal to in Django?

TOP Ranking

Article

Django Queryset: filter by weeks

Django Queryset: filter by weeks

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Double spacing in rmarkdown pdf

SQL Server : need add a dot before two last character

C++ 16 bit grayscale gradient image from 2D array

JMeter: Why get error when try to save test plan

JWT gives JsonWebTokenError "invalid token"

How to make thrown errors visible outside of a Promise?

How to tell if iOS Today Widget is being updated in the background?

Calling Doctrine clear() with an argument is deprecated

Capybara Selenium Chrome opens About Google Chrome

How to update azerothcore-wotlk docker container

Adding Ripple Effect to RecyclerView item

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Error while applying filter on dataframe - PySpark

Unable to add slack to bluemix project

MyPy fails dataclass argument with optional list of objects type

How can I validate and parse phone numbers to extract their country calling code and area code?

Single Sign-On in Spring by using SAML Extension and Shibboleth

python how to create many-to-many of lists inside one list