Datetime - Convert relative time delta to months

Give Feedback | Bug report

Tags: #datetime #relativedelta #calculate #date #time #dateutil

Author: Florent Ravenel

Last update: 2023-07-05 (Created: 2023-05-22)

Description: This notebook is designed to convert the relative time delta between two dates into months. By utilizing the relativedelta function, the conversion becomes more accurate compared to using timedelta, as relativedelta considers the varying number of days in each month.

References:

Input

Import libraries

In [ ]:

from datetime import datetime
from dateutil.relativedelta import relativedelta

Setup Variables

start_date: First date
end_date: Second date

In [ ]:

start_date = datetime(2022, 1, 15)
end_date = datetime(2023, 5, 22)

Model

Calculate delta and convert to months

Calculate the time delta between two dates using the relativedelta function from the dateutil library.

In [ ]:

delta = relativedelta(end_date, start_date)
months = round(delta.days / 30 + delta.months + 12 * delta.years, 1)

Output

Display result

In [ ]:

print(f"The time delta is {months} months.")