SQL Query:How to use a variable for number of days in a DATEADD expression.

Question

Joe Frisbie 21

I am not so good at SQL, however, I am trying to take a DATEADD expression we use in an SCCM SSRS report

"Where GSWS.[LastHWScan] >= DATEADD(DAY, -60, GETDATE()) "

And change the -60 entry to use a variable "@NumberOfDays" we prompt for when running the report.

Answer 1

Viorel 89,136

Ronen Ariely 14,146 Reputation points MVP

2022-02-03T22:28:18.877+00:00

Why you added this message as comment and not as answer?

This looks the answer, but the OP cannot mark it.
ZoeHui-MSFT 20,176 Reputation points

2022-02-04T01:57:11.367+00:00

Hi @Joe Frisbie ,

Helped convert Viorel-1's comment as answer.

As Viorel-1 said, you may replace -60 with @NumberOfDays.

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.
Ronen Ariely 14,146 Reputation points MVP

2022-02-04T16:07:39.237+00:00

Helped convert Zoehui-MSFT's response to comment, as it should be

Answer 2

Joe Frisbie 21

Thank you all, it works. Now I have to understand how to add the variable as a dataset in SSRS to put it all together.

1 additional answer