[FIXED] How to use greater than and less than or equal in django filter query

Issue

I am trying to filter data where added in between from date and to date. but i'm getting Cannot resolve keyword 'date_gte' into field.

How can i resolve this issue?

    from1 = request.POST.get('from')
    to = request.POST.get('to')
    result = qwerty.objects.filter(date_gte= from1, date_lte= to)
    print(result)
    result.save()

Solution

You need to use two consecutive underscores (__) to use a lookup:

from1 = request.POST.get('from')
to = request.POST.get('to')
result = qwerty.objects.filter(date__gte=from1, date__lte=to)
print(result)
result.save()

In this case, you can make use of the __range lookup ^[Django-doc]:

from1 = request.POST.get('from')
to = request.POST.get('to')
result = qwerty.objects.filter(date__range=(from1, to))
print(result)
result.save()

Answered By - Willem Van Onsem