Date interval and auto increment

We created a tool that would collect data within an interval of 12 months
consecutively of the past year, how do we go about date limit and date auto
increment

Regards
Deo Mtundu