Search:
Search questions and share your knowledge with the world here on Questionpoint.

Interview Question in SQL Server Reporting Services (SSRS)

I am wanting to use a parameter in a report that specifies not just a single date, but a range of dates. How might I go about doing this?

Answers to "In MS SQL Server 2005 Reporting Services, how do I use parameters for date ranges"

RE: In MS SQL Server 2005 Reporting Services, how do I use parameters for date ranges?
The way I always do this is to use two date parameters, for StartDate and EndDate. Then you could change the query to say "Where ProjectStartDate between @StartDate and @EndDate" Keep in mind that the date parameters do not have times specified, so if your field does have a time component, you'd want to clean that up. My favorite way is convert(varchar(10), ProjectStartDate, 101).
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Search questions and share your knowledge with the world here on Questionpoint.