Getting a list of months between two dates

Question

I need to implement the code which will help me to get the list of months between two dates.

I already have the code which will give the month delta , That is the number of months.

Actually, I need the way to achieve getting the list of months between two dates.

Here it is code for getting month delta.

import calendar
import datetime

def calculate_monthdelta(date1, date2):
    def is_last_day_of_the_month(date):
        days_in_month = calendar.monthrange(date.year, date.month)[1]
        return date.day == days_in_month
    imaginary_day_2 = 31 if is_last_day_of_the_month(date2) else date2.day
    monthdelta = (
        (date2.month - date1.month) +
        (date2.year - date1.year) * 12 +
        (-1 if date1.day > imaginary_day_2 else 0)
        )
    print monthdelta
    return monthdelta

date2 = datetime.datetime.today()
date1 = date2.replace(month=01)

calculate_monthdelta(date1, date2)

Now I need the way to get the list of months between the same.

Any help is appreciated If there is any way to get the list of months between two dates.

Note: Please suggest any idea (If available) apart from the code I have used here.

refer : http://stackoverflow.com/questions/4039879/best-way-to-find-the-months-between-two-dates — Harsha Biyani, May 26 '16 at 09:17
https://stackoverflow.com/questions/34898525/generate-list-of-months-between-interval-in-python/34899127 ? — Lev, Jun 06 '19 at 19:32

score 13 · Answer 1 · answered May 26 '16 at 11:21

13

try this

import datetime
import time
from dateutil.rrule import rrule, MONTHLY
months = [dt.strftime("%m") for dt in rrule(MONTHLY, dtstart=date1, until=date2)]
print months

answered May 26 '16 at 11:21

cheng chen

469
4
6

score 0 · Answer 2 · answered May 26 '16 at 09:45

0

from datetime import datetime,timedelta
import time
d = date1
delta = timedelta(months=1)
while d <= date2:
    print d.strftime("%m")
    d += delta

answered May 26 '16 at 09:45

cheng chen

469
4
6

1

That was the very first thing came to my mind too, but, `timedelta` does not accept months. – Muhammad Tahir May 26 '16 at 09:59
you are right, an other answer is provided (below). – cheng chen May 26 '16 at 11:29

score -1 · Answer 3 · edited May 26 '16 at 10:32

-1

Change your print statement to:
print calendar.month_name[:monthdelta]

edited May 26 '16 at 10:32

shivsn

6,820
24
33

answered May 26 '16 at 09:41

NNNN

1
2

score -1 · Answer 4 · answered May 26 '16 at 09:57

Because I don't know your desired output I can't format mine, but this returns an integer of the total number of months between two dates.

def calculate_monthdelta(date1, date2):
    print abs(date1.year - date2.year) * 12 + abs(date1.month - date2.month)

Getting a list of months between two dates

4 Answers4