Iam generating a report to identify items that have not been used in a year. I have a last used date field in the database. How do I excluded from the current date minus one year so only old items appear?

Filter out in your query:

declare @NewDate varchar(10)
set @NewDate = Month(getdate()) + '/' + Day(getdate()) + '/' + (Year(getdate()) - 1)

select ... where @LastUsedDate < convert(datetime, @NewDate)

Brian

Iam new to reporting services, how do I do a declare within report services or is this done elsewhere?
Thanks for your response.

I wasn't sure where you created the query. This response was more for a stored procedure that the report would execute. You probably can do something similar through a query in reporting services.

Brian