I'm sure there would be a way of passing the required dates as a variable to the stored procedures., or, if it is always the current date, why not use the GETDATE() function.

If these two ideas can't work, then post one of your simpler stored procs, with an explanation of the dates you need to change.