I tried several CAML query builder for generating query but its not generating correct Query.

I want to query calender list with following logic

StartDate >= Today  And EndDate <= Today


BookedBY= TestUser OR HostedBy= TestUser OR CreatedBY = TestUser


BookingStatus!=Cancelled OR BookingStatus!= HostCancelled

Please Help

  • Can you post the query you tried so far? Do you want to expand Recurring events also? – Amal Hashim Nov 27 '14 at 12:57
  • No recurrent events not required – SharePointMan Nov 27 '14 at 13:23
  • Your logic seems not correct. I think it should be StartDate<=Today AND EndDate>=Today. Your logic will not return any values I believe. – Amal Hashim Nov 27 '14 at 13:27
  • I want to return today values.your logic wl return all values including tomorrow as end date is greater thn today – SharePointMan Nov 28 '14 at 3:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.