Do you have the option of using Data Driven subscriptions in Reporting Services?

If you do, then you can set up the data driven subscription with start and end date parameters.

If you don't, then you can put the date range in your report data set.

Once you answer this question, then I can give you more detailed instructions.