Enumerate a DateRange

Question

I have 2 dates and I am trying to build labels of an x-axis of a plot.

As such, I need a way to take 2 datetime objects, i.e 2009-10-12 00:00:00 and 2009-10-20 00:00:00 and generate a list like so:

["2009-10-12", "2009-10-13", "2009-10-14", ..., "2009-10-19", "2009-10-20"]

What libraries should I use to assist? I have a feeling the datetime module and the timedelta functionality will help quite a bit.

I can include code if it makes sense to, but I have a feeling there's something built in to the python libraries that allow for this to be real easy. I seem to just be missing it.

http://stackoverflow.com/questions/1950098/does-python-have-any-for-loop-equivalent-not-foreach — mechanical_meat, Jan 25 '10 at 22:34
Exact Duplicate: http://stackoverflow.com/questions/1060279/iterating-through-a-range-of-dates-in-python — S.Lott, Jan 25 '10 at 23:01

unutbu · Accepted Answer · 2010-01-26T00:06:51.937

2

import datetime

first=datetime.date(2009,10,12)
last=datetime.date(2009,10,20)
adate=first
dates=[]
while adate<=last:
    dates.append(adate)
    adate+=datetime.timedelta(1)
print(dates)

Or, for lovers of list comprehension:

len=(last-first).days
dates=[first+datetime.timedelta(n) for n in range(len+1)]

edited Jan 26 '10 at 00:06

answered Jan 25 '10 at 22:31

unutbu

842,883
184
1,785
1,677

Thanks: I really love comprehensions :) – Attila O. Jan 26 '10 at 01:14

Attila O. · Answer 2 · 2010-01-25T22:44:24.117

0

from datetime import date, timedelta

a, b = date(1010, 10, 12), date(1010, 10, 20)
times = [a + timedelta(x) for x in xrange((b-a).days)]

# If you want to format them:
times = [x.strftime('%Y-%m-%d') for x in times]

edited Jan 25 '10 at 22:44

answered Jan 25 '10 at 22:35

Attila O.

15,659
11
54
84

This is with datetime.date objects, but datetime.datetime should work the same. – Attila O. Jan 25 '10 at 22:37

Enumerate a DateRange

2 Answers2