how to subtract days from current date and return date object in pandas

Question

I want to subtract 30 days from current date and get date in following format.

  final_date = 2019-12-24

I am doing following thing in pandas, but getting timestamp object in return

  final_date = pd.to_datetime(pd.datetime.now().date() - timedelta(30))

How can I do it in pandas?

Answer 1

There is more solution for subtract today by Timestamp.floor with timedeltas or offsets:

final_date =  pd.Timestamp.now().floor('d') - pd.Timedelta(30, unit='d')
final_date =  pd.to_datetime('now').floor('d') - pd.DateOffset(days=30)
final_date =  pd.to_datetime('now').floor('d') - pd.offsets.Day(30)

---

print (final_date)
2019-12-24 00:00:00

And last convert output to python object dates:

print (final_date.date())
2019-12-24

Or to strings:

print (final_date.strftime('%Y-%m-%d'))
2019-12-24

Answer 2

Use Series.strftime:

final_date = (pd.datetime.now().date() - pd.Timedelta(days = 30)).strftime('%Y-%m-%d')
#'2019-12-24'