CODEWITHSUNDEEP
pythonpython-dateutilrelativedelta
user2422457
user2422457

Reputation:

dateutil.relativedelta - How to get duration in days?

I wish to get the total duration of a relativedelta in terms of days.

Expected: 

dateutil.timedelta(1 month, 24 days) -> dateutil.timedelta(55 days)

What I tried:

dateutil.timedelta(1 month, 24 days).days -> 24 (WRONG)

Is there a simple way to do this? Thanks!

Upvotes: 18

Views: 24275

Answers (3)

Marcel Wilson
Marcel Wilson

Reputation: 4572

This one bothered me as well. There isn't a very clean way to get the span of time in a particular unit. This is partly because of the date-range dependency on units.

relativedelta() takes an argument for months. But when you think about how long a month is, the answer is "it depends". With that said, it's technically impossible to convert a relativedelta() directly to days, without knowing which days the delta lands on.

Here is what I ended up doing.

from datetime import datetime, timedelta
from dateutil.relativedelta import relativedelta

rd = relativedelta(years=3, months=7, days=19)
# I use 'now', but you may want to adjust your start and end range 
# to a specific set of dates.
now = datetime.now()

# calculate the date difference from the relativedelta span
then = now - rd
# unlike normal timedelta 'then' is returned as a datetime
# subtracting two dates will give you a timedelta 
# which contains the value you're looking for
diff = now - then

print diff.days

Upvotes: 18

Manyu
Manyu

Reputation: 142

In many situations you have a much restricted relativedelta, in my case, my relativedelta had only relative fields set (years, months, weeks, and days) and no other field. You may be able to get away with the simple method.

This is definitely off by few days, but it may be all you need

(365 * duration.years) + (30 * duration.months) + (duration.days)

Upvotes: -1

egvo
egvo

Reputation: 1865

Simple date diff does it actually.

    >>> from datetime import datetime
    >>> (datetime(2017, 12, 1) - datetime(2018, 1, 1)).days
    -31

To get positive number You can swap dates or use abs:

    >>> abs((datetime(2017, 12, 1) - datetime(2018, 1, 1)).days)
    31

Upvotes: 8

Related Questions