I am using CAML query for SharePoint calender list. I am able fetch proper daily data. but when i choose weekly, monthly and yearly, it doesn't give me reports as expected. it doesn't take date specified rather it takes start date of present week.
how can i solve this problem?
qryBookings.Query =
"<Where>
<And>
<DateRangesOverlap>
<FieldRef Name='EventDate'/>
<FieldRef Name='EndDate'/>
<FieldRef Name='RecurrenceID'/>
<Value Type='DateTime'>
<Week/>
</Value>
</DateRangesOverlap>
<And>
<Eq>
<FieldRef Name='Place'/>
<Value Type='Lookup'>" + d.SelectedItem.Text + "</Value>
</Eq>
<Eq>
<FieldRef Name='Test'/>
<Value Type='Lookup'>" + R.SelectedItem.Text + "</Value>
</Eq>
</And>
</And>
</Where>";
qryBookings.CalendarDate = DateTime.Parse(txtDate.Text);
qryBookings.ExpandRecurrence = true;