TypeError: '>' not supported between instances of 'datetime.datetime' and 'str'

python string datetime python-datetime
Ebin Davis picture Ebin Davis · Nov 11, 2018 · Viewed 38.2k times · Source

I am new to python date and time types.

I have a date value.

date = '2018-11-10 10:55:31+00:00'

I need to check this date value is older than 90 days.

I tried :

from datetime import datetime
from datetime import timedelta

past = datetime.now() - timedelta(days=90)
date = '2018-11-10 10:55:31+00:00'

if past > date :
   print("This is older than 90 days")

failing with the following error :
TypeError: '>' not supported between instances of 'datetime.datetime' and 'str'

This might be because the date format for 'past' and the date value which I passed is different.

How can I come up with this ?

Answer

PilouPili picture PilouPili · Nov 11, 2018

You have to use strptime to convert a string into a date.

The comparaison operator only applies between datetime.

date = datetime.strptime('2018-11-10 10:55:31', '%Y-%m-%d %H:%M:%S')

then can you do

if past > date :
   print("This is older than 90 days")

Related questions

How to change the datetime format in pandas

My dataframe has a DOB column (example format 1/1/2016) which by default gets converted to pandas dtype 'object': DOB object Converting this to date format with df['DOB'] = pd.to_datetime(df['DOB']), the date gets converted to: 2016-01-26 and …

Read More
Format timedelta to string

I'm having trouble formatting a datetime.timedelta object. Here's what I'm trying to do: I have a list of objects and one of the members of the class of the object is a timedelta object that shows the duration of …

Read More
Why is datetime.strptime not working in this simple example?

I'm using strptime to convert a date string into a datetime. According to the linked page, formatting like this should work: >>> # Using datetime.strptime() >>> dt = datetime.strptime("21/11/06 16:30", "%d/%m/%y %H:%M") My code …

Read More