Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

with what I hope to be a parameter for a date/time variable. The business requirement is that I pa

Status
Not open for further replies.

xarzu

IS-IT--Management
Jan 16, 2012
19
US
I am setting a data-driven subscription in SSRS with what I hope to be a parameter for a date/time variable. The business requirement is that I pass a Parmenter to the report that needs to be set to yesterday's date from when the subscribed email alert is sent.

This is a query I am using in a data-driven subscription in SSRS. How to I make the following SQL query return the previous date instead of the current system date:

SELECT CONVERT (date, SYSDATETIME()) as rundate
 
SELECT convert (date, DATEADD (DAY, -1 , SYSDATETIME())) as rundate
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top