0

I am trying to find the first and last date of the previous five months from now using python.

today = datetime.today()
 first = today.replace(day=1)
 lastMonth = first - timedelta(days=153)

Now how do i find the first and last date of each of the previous five months in python?

Can anyone help me with this please?

user86907
  • 817
  • 9
  • 21
  • Does this answer your question? [How to get the last day of the month?](https://stackoverflow.com/questions/42950/how-to-get-the-last-day-of-the-month) – PacketLoss Oct 01 '20 at 02:54
  • Yeah but the problem is that how do i go back in time and get the last and first dates of each month. – user86907 Oct 01 '20 at 03:34

1 Answers1

1

The below is based off an two answers already on SO. It adds in the ability to respond with the first and last day over a range of dates.

Get year month for last X months

How to get the first and last day of the month

import calendar
import datetime
from dateutil.relativedelta import relativedelta


def get_last_months(start_date, months):
    for i in range(months):
        _, num_days = calendar.monthrange(start_date.year,start_date.month)

        first_day = datetime.date(start_date.year, start_date.month, 1).strftime('%Y-%m-%d')
        last_day = datetime.date(start_date.year, start_date.month, num_days).strftime('%Y-%m-%d')
        
        yield (first_day, last_day)
        start_date += relativedelta(months = -1)


months_back = 5

print([i for i in get_last_months(datetime.datetime.today(), months_back)])

Output:

[('2020-10-01', '2020-10-31'), ('2020-09-01', '2020-09-30'), ('2020-08-01', '2020-08-31'), ('2020-07-01', '2020-07-31'), ('2020-06-01', '2020-06-30')]
PacketLoss
  • 5,561
  • 1
  • 9
  • 27