for cyclic sentence using date type

[#1]

I want to use date type in for sentence

for a = ‘2012-01-01’ to '2012-10-01'

but it seems not working?

[#2]

I mean 2012-01-01 next would be 2012-02-01 not 2012-01-02,how could i make it?