I'm new to CAML type queries. I'm trying to integrate sharepoint calendar data into a SSRS report. I pretty much need to do the following WHERE clause
(EventDate <= @StartDate AND EndDate >= @EndDate) OR (EventDate >= @StartDate AND EndDate <= @EndDate)
I need to include times into it as well. Can anyone please help me - as everything I have tried hasnt given the desired results.
Thanks!