Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hambo12
Starting Member
7 Posts |
 Posted - 2009-08-31 : 00:07:32
|
| I have created a matrix that displays some grouped information for a certain date. However, I want it to display the information for a date range. So I want the user to be able to enter the date ranges, and the matrix include all data within those date ranges.Is there any way to do this? I have added two paramters, "from date" and "to date", however it creates a seperate matrix for each date. |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-31 : 09:12:59
|
| This sounds like something I was trying to do Friday of last week. Is it possible the matrix results are because the time is also part of the datetime field? Instead of a normal datetime column, generate one like this:CONVERT(varchar(10), Orig_Date, 111) AS [New Date]This effectively drops the time portion. John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Matrix - Range of dates