How to calculate diff between two dates in django

Question

I want to calculate days difference between current date and previous date. i am trying this code

requiremntObj = CustomerLeads.objects.all()
a = datetime.datetime.now().date()

for i in requiremntObj:
    date1=i.posting_date
    diff = a-date1
    print diff

I got a error unsupported operand type(s) for -: 'datetime.date' and 'unicode'

For current date i am getting datetime object and for date1 i am getting unicode.

posting_date = models.DateField()

What does the `CustomerLeads` model look like? Is `posting_date` a proper [DateTimeField](https://docs.djangoproject.com/en/1.10/ref/models/fields/#datetimefield)? If not: Fix your model! — dhke, Dec 19 '16 at 19:53

score 15 · Accepted Answer · edited May 23 '17 at 11:45

15

If you have DateTimeField you can use:

delta = datetime.now().date() - posting_date
print delta.days

If it is string, then you have to convert:

from datetime import datetime
date_format = "%m/%d/%Y"
a = datetime.strptime(str(datetime.now().date()), date_format)
b = datetime.strptime(str(posting_date), date_format)
delta = b - a
print delta.days

Here is post.

edited May 23 '17 at 11:45

Community

1
1

answered Dec 19 '16 at 20:00

Zagorodniy Olexiy

2,132
3
22
47

i am getting this error type object 'datetime.datetime' has no attribute 'datetime' – vikrant Verma Dec 19 '16 at 20:10
1

Replace `datetime.datetime.now()` in the answer code with `datetime.now()` – Mad Wombat Dec 19 '16 at 20:12
1

Thanks it is working but a = datetime.strptime(str(datetime.now().date()), date_format) – vikrant Verma Dec 19 '16 at 20:18

score 3 · Answer 2 · edited Oct 21 '19 at 17:23

3

This code for HTML in Django

<p> {{ to_date|timeuntil:from_date }} </p>

This code for server site in python

import datetime

from_date = datetime.datetime(2019, 10, 21)

to_date   = datetime.datetime(2019, 10, 25)

result = to_date - from_date
print(result.days)

edited Oct 21 '19 at 17:23

FZs

16,581
13
41
50

answered Oct 21 '19 at 16:53

jahurul25

159
4

How to calculate diff between two dates in django

2 Answers2

Linked