Python : Subtract 1 month from date

Question

I want subtract 1 month from a date. I'm using relativedelta but this subtract 6 months.

print('the max date : ' , all_data['DT_ANO'].max())
dt_start = all_data['DT_ANO'].max() - relativedelta(month = 1)
print('dt_start : ' , dt_start)

I get this result :

the max date :  2021-08-16 00:00:00
dt_start :  2021-01-16 00:00:00

instead of :

the max date :  2021-08-16 00:00:00
dt_start :  2021-07-16 00:00:00

I think you should be using `datetime.timedelta` rather than `dateutil.relativedelta` — Adam Smith, Nov 26 '21 at 09:27

score 4 · Accepted Answer · answered Nov 26 '21 at 09:29

4

Guessing that relativedelta is a dateutil function, then use

relativedelta(months=1)

If you use month, year, day, ... the value will be absolute, if you use months, days, years, the value will be relative.

answered Nov 26 '21 at 09:29

Petr Blahos

1 Answers1