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 |
|
rohitnegi09
Starting Member
2 Posts |
 Posted - 2014-08-05 : 15:14:10
|
| Hi All,i am doing search through Date Range but didn't get correct result.For Example if i created a Task on 5/8/2014 and when i have take Date Range from 1/8/2014 to 6/8/2014 then didn't get 5/8/2014 data in result but when i taken range from 1/8/2014 to 5/8/2014 then got the 5th Date data. I am taking Range Inclusive Operator(:).SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) )I need help ASAP.Thanks. |
|
|
rohitnegi09
Starting Member
2 Posts |
Posted - 2014-08-06 : 02:57:29
|
| Again Posting with more information -I am working on TFS 2010 Report with Report Builder 3.0.I need to fetch data on basis of Start Task Date(means when user start their task).So i have added a new field in a TFS Work Item Template with name StartTaskDate.Now i have created new DataSet in ReportBuilder where i have taken StartTaskDate as a Parameter(Inclusive Date Range).This Parameter have created automatically 2 DatePicker parameter in Report.I have changed Format of Parameter in DataSet properties .mention below-="[Work Item].[System_CreatedDate].&[" + Format(CDate(Parameters!ToWorkItemSystemCreatedDate.Value), "yyyy-MM-dd")+"T00:00:00]"Now i am trying to search data between 2 dates from DatePicker .For Example if i created a Task on 5/8/2014 and when i have take Date Range from 1/8/2014 to 6/8/2014 then didn't get 5/8/2014 data in result but when i taken range from 1/8/2014 to 5/8/2014 then i got the 5/8/2014 date data.in mdx query i have taken below mwntion query -SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) )At last my issue is i am not getting correct result set.Please let me know if need more info. |
 |
|
|
|
|
|
MDX Date Range Report - Didn't get correct Result