Not sure if I understood the question correctly, but perhaps you can use a static sql statement like:
SELECT ...
FROM YourTable
WHERE DateColumn >= @start
AND DateColumn < @end
Regardless of the dates the query would always be the same. If you query:
- for a single date, for example @start = 25/5/2012, @end = 26/5/2012 (current date + 1)
- tomorrow, @start = 26/5/2012, @end = 27/5/2012 (current date + 1 and 2)
- for date range @start = 17/5/2012, @end = 22/5/2012