Last post Sep 27, 2016 05:07 AM by SuperRyden
Sep 26, 2016 07:22 AM|SuperRyden|LINK
Hello, I`m making a stored procedure, and have a question.
As you can see, I want to select date last modified date = not changed for more than six months.
For example today is 26/09/2016, so if I execute that SP, modified date is before 26/03/2016 items showed.
Please, help me how can I make it, Your advice or give me some examples or tutorials about that. Thanks
Sep 26, 2016 07:34 AM|wmec|LINK
where [last modified date] < dateadd("m",-6,getdate())
Sep 27, 2016 05:07 AM|SuperRyden|LINK
Oh Thank you wmec, I tested it in my SP and it works well!!!