I have a list which contains 3 columns -ID, TicketState and EndDate
ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed 01/12/2012 3 Discard 05/05/2011 4 Open 28/05/2013 5 Discard 10/11/2012 So, I want to retrieve those items whose TicketState is Either Closed OR Discard, AND EndDate < 1 year (from todays Date)
For that i have written following CAML Query but it is not working....
SPQuery myquery = new SPQuery();
myquery.Query = "<Where>" +
"<And>" +
"<Or>" +
"<Eq><FieldRef Name='TicketState' /><Value Type='Choice'>Closed</Value></Eq>" +
"<Eq><FieldRef Name='TicketState' /><Value Type='Choice'>Discard</Value></Eq>" +
"</Or>" +
"<Geq><FieldRef Name='End_x0020_Time' /><Value Type='DateTime' IncludeTimeValue='FALSE'><Today Offset='-365' /></Value></Geq>" +
"</And>" +
"</Where>";
EDIT:
Solved. Problem was with the internal name.