A forum poster wanted to use a StartDate parameter to limit the range of dates available in a second parameter to that date through the end of the same year.
This can be done if you would like to use drop-down list of dates. To do this, use a query to return a string type column with the date that you can convert back to a date. When you use a date time type parameter, a standard date picker control is used, which has the capability of selecting any date beween 1-1-1753 and 12-31-9998.
If you would like to use the first technique, the following query will work to populate the parameter drop-down list. You need to manually set the @StartDate query parameter to a report parameter to pass in this value.< Convert(Date, Convert(char(4), Year(@StartDate)) + '-12-31') begin set @TheDate = DateAdd(Day, 1, @TheDate) insert into #DateList Values(Convert(char(10), @TheDate, 101), @TheDate) end select * from #DateList drop table #DateListcreate table #DateList (DateString char(10), DateValue date) declare @TheDate Date set @TheDate = @StartDate insert into #DateList Values(Convert(char(10), @TheDate, 101), @TheDate) While @TheDate
MSDN Forum thread: Date Range
Weblog by Paul Turley and SQL Server BI Blog.



Subscribe to this blog
Briefcase
Print
No comments.