February 11, 2019 at 4:45 pm
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
February 11, 2019 at 5:07 pm
wm.m.thompson - Monday, February 11, 2019 4:45 PMI 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(d, -1, SYSDATETIME())) as rundate
Sue
February 11, 2019 at 5:41 pm
Sue_H - Monday, February 11, 2019 5:07 PMwm.m.thompson - Monday, February 11, 2019 4:45 PMI 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(d, -1, SYSDATETIME())) as rundate
Sue
Thanks Sue. Great minds think alike. I just came up with
SELECT convert (date, DATEADD (DAY, -1 , SYSDATETIME())) as rundate
too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply