Report builder 2.0 - Subscriptions

Hi All,

I hope someone can help.

I have created a number of reports using report builder, and am currently having them emailed to me on monthly intervals. My problem is however, I am required to keep changing the date parameters i.e. from / to dates.

Is there a way that I can command the Report Parameter Values to recognised the date that the report is sent as the required dates i.e. sent on 31/5/2012 @23:59, and report parameters would set themselves as start 01/05/2012 @ 00:01 and end 31/5/2012 @23:59?

Many thanks for sparing your time to have a look.

Clash

That'll be MS SQL Server Report Builder?

If it is then you can use GETDATE().