"Kenny" <kvu@thereturnexchange.com> wrote in message
news:1109901951.312549.259440@o13g2000cwo.googlegroups.com...
>I have a report that every Monday at 1:00AM, should run a report for
> the previous week (Mon-Sun). If it only had to run for the previous
> week, I would just get the dates in the stored procedure using
> getdate() and dateadd(). However, when the report is viewed on-demand,
> I want the user to be able to specify any start and end date, so the
> report must have StartDate and EndDate as parameters.
>
> When setting up the subscription is there anyway to avoid entering
> hard-coded dates? I know I can get around it with some trickery in the
> stored proc (e.g.- checking to see if start and end date parameters are
> null) but I'd rather not.
>
> Much thanks for any help!
>