I am trying to create a subscription for a report that has a datetime parameter. I was wondering if there was a way to set the parameter to the current date that the report is being executed. I have tried using "@ExecutionTime" and it rejects it since its not in a date format. Would it just be better to create a seperate report just for the subscription and use GetDate() directly in the stored procedure?
(The current report needs to have the date user-entered so they can run it for any date)