How to specify today's date for a parameter when running a proc

meddojeddo 1 Reputation point
2021-03-29T14:32:08.263+00:00

I am trying to a DDS where the subscription is triggered and send a a report in an email when there is data for the current date. But I am not sure how to specify the current date when specifying the script to execute the stored procedure in the DDS setup.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-03-30T02:13:02.847+00:00

    Hi @meddojeddo ,
    What is your date? I am sorry I don't understand what you mean。
    Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments