convert string to date in Python

Question

Python newbie here, so this is probably an easy question. I'm trying to extract part of a string and convert it to date format (there's no time involved). I'm trying to copy approaches I've seen online, but I get the message

ValueError: time data '2017-07-10' does not match format '%y-%m-%d'.

I'm probably using the wrong format somewhere, and I'm not sure how to proceed. Thanks very much for any suggestions you may have.

#convert the audit_date to a list so it can be
# sliced
audit_date_list = list(audit_date)
# Slice audit_date_list to get chars at indexes
# 13-22
# only, then join those chars
audit_date_slice = "".join(audit_date_list[13:23])
#convert audit_date_slice to date format
audit_date_final = datetime.datetime.strptime(audit_date_slice, '%y-%m-%d').date()
print(audit_date_final)

Hi, I see you're new to SO. If you feel an answer solved the problem, please mark it as 'accepted’ by clicking the green check mark. This helps keep the focus on older SO which still don't have answers. — fferri
– fferri, Commented May 1, 2018 at 18:31

fferri · Accepted Answer · 2018-04-16 22:07:29Z

3

Use capital Y for four-digits year:

audit_date_final = datetime.datetime.strptime(audit_date_slice, '%Y-%m-%d').date()

answered Apr 16, 2018 at 22:07

fferri

19k8 gold badges57 silver badges110 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bubble Bubble Bubble Gut · Accepted Answer · 2018-04-16 22:20:58Z

1

If you don't want to remember the format, try using dateutil, it recognizes most of the formats and it's shipped with Anaconda.

from dateutil import parser

audit_date_final = parser.parse(audit_date_slice)

answered Apr 16, 2018 at 22:20

Bubble Bubble Bubble Gut

3,37617 silver badges30 bronze badges

Collectives™ on Stack Overflow

convert string to date in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related