This is my code:
MYDATE = []
start_date = "2011-01-01"
stop_date = "2013-05-01"
start = start_date.strftime("%Y-%m-%d")
stop = stop_date.strftime("%Y-%m-%d")
for r in .......:
MYDATE.append((r,r))
How can I iterate over Date betweet start_date and stop_date?
Well it depends on how you wish to iterate. By days? by months? Using timedelta will solve your problem.
from datetime import datetime
start_date = "2011-01-01"
stop_date = "2013-05-01"
start = datetime.strptime(start_date, "%Y-%m-%d")
stop = datetime.strptime(stop_date, "%Y-%m-%d")
from datetime import timedelta
while start < stop:
start = start + timedelta(days=1) # increase day one by one
Another approach to itearete through months is using relativedelta
from dateutil.relativedelta import relativedelta
start = start + relativedelta(months = +1)
What about timedelta?
start = datetime.now()
end = start + timedelta(days=10)
tmp = start
while tmp < end:
print tmp
tmp = tmp + timedelta(days=1) # replace the interval at will
prints
2014-04-07 10:42:14.943790
2014-04-08 10:42:14.943790
2014-04-09 10:42:14.943790
2014-04-10 10:42:14.943790
2014-04-11 10:42:14.943790
2014-04-12 10:42:14.943790
2014-04-13 10:42:14.943790
2014-04-14 10:42:14.943790
2014-04-15 10:42:14.943790
2014-04-16 10:42:14.943790
whileloop e.g.while newdate < stop:I don't know if there's an easy way to add months, but I did see this: stackoverflow.com/questions/4130922/…strftime()on a string object?