I am trying to query startDate=12-16-2014 AND endDate=12-16-2014 and the results im getting like below
12-16-2014 , 12-18-2014, 12-22-2014, 3-15-2014, 3-1-2014.
Can someone suggest why 3-15-2014 and 3-1-2014 are returning?
Which product/technology are you working with? This is actually the Community Suggestions section of the community - I'll move your question to a more relevant board so that those experts will see it if you let me know where it should be moved.
Im working on Teamsite 7.3.2
AniSen123 wrote: I am trying to query startDate=12-16-2014 AND endDate=12-16-2014 and the results im getting like below 12-16-2014 , 12-18-2014, 12-22-2014, 3-15-2014, 3-1-2014. Can someone suggest why 3-15-2014 and 3-1-2014 are returning?
First - your query doesnt make sense - endDate should never be less-than-or-equal to startDate, so querying for startDate and endDate to be greater-than-or-equal to the same date should be pointless, just query on the startDate in that case.
I'm not sure if it matters, but I tend to use YYYY-MM-DD format rather than MM-DD-YYYY.
Try changing your query to be:
startDate=2014-12-16
or if you really want:
startDate=2014-12-16 AND endDate=2014-12-16
TYpically you want StartDate<TODAY AND EndDate>TODAY
you have both start and end > TODAY which means you get anything starts and ends in the future.
=12-16-2014 AND endDate=12-16-2014 and the results im getting like below
