Django (1.11) ORM using postgresql query is not able to compare date

Question

Django (1.11) ORM using postgresql query is not able to compare date. I need data in between of leave_date_from and leave_date_to. I'm expecting one record.

My model is as follows:

class EmployeeLeaveApp(models.Model):
    user = models.ForeignKey(User, models.DO_NOTHING, on_delete=models.CASCADE)
    leave_date_from = models.DateField(blank=True, null=True)
    leave_date_to = models.DateField(blank=True, null=True)

My View query is :

inputdate = '2018-03-05'
duplicateleave = crm_models.EmployeeLeaveApp.objects.filter(
    leave_date_from__gte=inputdate,
    leave_date_to__lte=inputdate,
    user=user)

My table data is like below:

leave_date_from | leave_date_to | user
2018-03-01      | 2018-03-10    | 1
2018-03-07      | 2018-03-22    | 1

So far, I tried many solutions but no luck.

@sakthiselvam Why so? I need to check that input (date) is in between of particular record. — Anup Yadav
– Anup Yadav, Commented Feb 12, 2018 at 12:14

Anup Yadav · Accepted Answer · 2018-02-12 13:34:30Z

2

from datetime import datetime    
inputdate = datetime.strptime(inputdate, '%Y-%m-%d')    
duplicateleave = crm_models.EmployeeLeaveApp.objects.filter(
    leave_date_from__gte=inputdate,
    leave_date_to__lte=inputdate,
    user=user
)

==== OR ==== If error comes must be str, not datetime.date then use.

inputdate = datetime.strptime(str(inputdate), '%Y-%m-%d')
duplicateleave = crm_models.EmployeeLeaveApp.objects.filter(
    leave_date_from__gte=inputdate,
    leave_date_to__lte=inputdate,
    user=user
)

django expects a dateobject in the parameter, but you are passing string to it. so use this

edited Feb 12, 2018 at 13:34

Anup Yadav

3,0153 gold badges24 silver badges31 bronze badges

answered Feb 12, 2018 at 12:11

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

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

5 Comments

Anup Yadav Over a year ago

Nope, not working. Though I tried this solution from SO.

Exprator Over a year ago

how are you passing the user parameter? can you show that?

Anup Yadav Over a year ago

I'm using REST Framework, so I got error due to your solution, so I type casted that to date to str like inputdate = datetime.strptime(str(inputdate), '%Y-%m-%d')

Exprator Over a year ago

so are you getting data now?? and if not can you show your user value and how you are querying it?

Anup Yadav Over a year ago

Your part of solution got worked, please accept the edit, I'll except answer. Thanks.

Collectives™ on Stack Overflow

Django (1.11) ORM using postgresql query is not able to compare date

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related